Tugas Basis Data I ( Praktikum 5 )

SQL AGGREGATES

Gambar 1

Examples of Aggregates

Gambar 2

Aggregates and NULL values

Gambar 3

 Aggregate with GROUP BY

Gambar 4

GROUP BY with two columns

Gambar 5

Combining SELECTs

Gambar 6

Combining two tables with UNION

Gambar 7

UNION with duplicates

Gambar 8

 UNION ALL with duplicates

Gambar 9

INTERSECT returns only duplicated rows

Gambar 10

EXCEPT restricts output from the First SELECT

Gambar 11

Subqueries: Friends not in Dick Gleason's state

Gambar 12

Subqueries can replace some joins

Gambar 13

Correlated subquery

Gambar 14

NOT IN and Subqueries with NULL Values

Gambar 15

Customers who have no orders

Gambar 16

IN query rewritten using ANY and EXISTS

Gambar 17

Simulating outer joins

Gambar 18

Subqueries with UPDATE and DELETE

Gambar 19

Table creation with SELECT

TUGAS BASIS DATA I

          Praktikum 5

Nama   :  Eka Agusti Ningsih

Kelas    : 1 B / Teknik Informatika

NPM    :  1103058