BASIS DATA 1 : SQL AGGREGATES and JOINING TABLE

Posted by Bhayang Ratu Wahyunur
Teknik Informatika 1 B
Pertemuan 3

Aggregates

Aggregates 2

Using Group by

Using Having

Aggregates Null and Values

Group By With Two Columns

Joining Table

Creation Of Company Table

Insertion of Company Table

Finding a Costumer name using two queries

Finding a customer name using one query and 

Finding an order number for a customer name

Three table join

Employees who have taken orders for customer

Joining customer and employee

Joining part and employee

The statement table

Choosing a join key

One to many join

Unjoinned Table