Answer Happy

SQL
1. CREATE un INSERT (1 point )
Create meaningful example of database with one of following
table structure.
Made CREATE scripts for these tables.
(You can use data created by you in test 1)
Create INSERT scripts for tables. The
amount of data must be such that skills in combining, grouping and
applying analytical functions can be demonstrated.
Table B must have at least 20 entries, the other tables must
have at least 4 entries.
Tables and data must be in English.
All queries must also be accompanied by a textual
description.
2. JOIN (1 point )
Create a query that joins data from three tables, adds an
additional condition for data selection, and results in not showing
all columns.
3. GROUP BY (1 point )
Create a query that groups Table B data, displays multiple
aggregate functions, and selects data before and after
grouping.
4. JOIN and GROUP BY (1 point )
Create a query that groups a join of data from two tables.
5. Subquery (1 point )
Create a query in which two-column values are computed using a
context-sensitive subquery.
6. Subquery (1 point )
Create a query in which a non-trivial subquery appears in the
data selection condition.
DROP
Delete all tables or complete the
following tasks
7. CREATE+ (1 point )
Add another foreign key to the database structure, enter the
data corresponding to this foreign key.
8. JOIN (1 point )
Create a query that joins the data in Table B with Table A and
joins the data in Table B again.
9. SQL 'window' function (1 point )
Create a query for table B that contains one of the SQL 'window'
functions (is used over with partition
by).
DROP
Drop all tables