Untitled Lesson

A) Модель

B) Номерной знак

C) Год выпуска

D) Марка

A) first_name

B) last_name

C) student_id

D) birth_date

A) age | SUM(id)

-------------

16 | 27

17 | 22

B) age | SUM(id)

-------------

16 | 37

17 | 22

C) age | SUM(id)

-------------

16 | 37

17 | 22

18 | 10

19 | 15

D) age | SUM(id)

-------------

16 | 17

17 | 19

A)| category | sum(quantity * price) |

|--------------|------------------------|

| Electronics | 1900 |

| Clothing | 300 |

B) | category | sum(quantity * price) |

|--------------|------------------------|

| Electronics | 1900 |

C) | category | sum(quantity * price) |

|--------------|------------------------|

| (Пусто) | (Пусто) |

D) | category | sum(quantity * price) |

|--------------|------------------------|

| Electronics | 1000 |

| Clothing | 1000 |

A) Phone 600, Tablet 300, Monitor 200

B) Laptop 1000, Phone 600, Tablet 300

C) Phone 600, Tablet 300, Keyboard 50

D) Tablet 300, Monitor 200, Keyboard 50

A) Alice 5000, Charlie 3500, Alice 4500

B) Alice 5000, Alice 4500, Charlie 3500

C) Alice 5000, Alice 4500, Bob 4000, Charlie 3500

D) Alice 5000, Alice 4500

A) IT 17500, Sales 8500, Projects 70000

B) IT 17500, Sales 8500, Marketing 9500, Projects 70000

C) IT 17500, Projects 70000

D) HR 3000, Sales 8500, Projects 70000

IT 17500