I will send the picture of the ER diagram for reference, to come up with the queries.!
Use MySQL Server and MySQL Workbench to write/run the SQL queries below. For
each query, provide the following in Report 2:
? In about 2 lines, explain what the query returns.
Queries:
? 1 trivial query. Simple select with ordering.
? 2 medium difficulty queries. Queries that use composite condition for selection,
computations, aggregate function and grouping.
? 1 query that uses subquery.
? 2 queries that uses join (1 inner join, 1 left or right outer join).
? 1 view (query must use join hint: you can use one of the queries from the
previous question).
? 1 query that uses union.
? 1 custom stored function.
? 1 custom stored procedure.
