Tugas Basis Data I ( Praktikum 3 )

SQL Aggregates and Joining Tables

Gambar 1

 

Gambar 2

Examples of Aggregates

Gambar 3

Using By Group

Gambar 4

Using Having

 Gambar 5

Aggregates and NULL values

Gambar 6

GROUP BY with two columns

Gambar 7

Joining Table

Gambar 8

 Creation of Company Tables

Gambar 9

Insertion into Company Tables

Gambar 10

Finding a costumer name using two queries

Gambar 11

Finding a costumer name using one query

Gambar 12

Finding an order number for a costumer name

Gambar 13

Three - table join

Gambar 14

Four - table join

Gambar 15

Employees who have taken orders for costumers

Gambar 16

The Statename Table

Gambar 17

One to Many Joins

Gambar 18

Unjoined Tables

Gambar 19

Table Aliases and Self Joins

Gambar 20

Non Equijoins

Gambar 21

Ordering Multiple Parts ( Case )

Gambar 22

Queries Involving the Orderpart Table

TUGAS BASIS DATA I

        Praktikum 3

Nama   :  Eka Agusti Ningsih

Kelas    : 1 B / Teknik Informatika

NPM     : 1103058