SQL Examples

I have three sample SQL databases, and I need a list of example queries to demonstrate various features of PostgreSQL: - inner joins - left joins - right joins - full joins - cross joins - union - union all - intersect - except - basic subqueries - advanced subqueries I need at least 5 queries in each category, for each database. Queries should be submitted one after another as follows in a .md file: ##### Inner Join Join the `cust_hist` and `customer` tables to get the order id, product id, first name and last name associated with each order. ```sql SELECT [login to view URL], ch.prod_id, [login to view URL], [login to view URL] FROM cust_hist AS ch JOIN customers AS c ON [login to view URL] = [login to view URL]; ``` Examples should show off the specific feature, e.g. left join vs right join. If you've any questions, let me know.