Creating Final tables $($relations$)$ with constraints

Data loading $($at least $3$ records per table$)$

Query design $(3$ meaningful queries along with their results$)$

Please include complex queries: at least one query example for:

$1.$ Display data from multiple tables $($join$),$

$2.$ Query including group$-$by statement, order$-$by statement.

$3.$ Subquery.