Sql

1.) For the diagram above, show the codes for (will use a concat here and we can call it "worker") all of the employees and the managers. In the concat function, include the employee's name, the managers name, and their job title. (another concat function here and we can call it "bigBoss")

2.) For this one, I am going to need the orders, customers products, and the order details, to show the (concat the first and the last name) contact name, customer names, order date, quantity ordered, order number, buy price, product name, price each, for all sales in the planes products.

3.) Pretty much same as #2 but we will wanting high profit margin sales only for this. This is more than $50 (sale price of each - buy price of the product that is >50).

4.) Pretty much same as #3 but we wlll be creating a column called "Gain" and for the "gain" we use (price each - buy price). This time we will use 80% profit margin. Order from highest to lowest profit.

5.) show city, country, payment date, customer name (and not the contact), and payment amount for all of the customers.