SQL ClassicModels Database

Query 1. List product names, product line and the difference between the MSRP and purchase(buy) price of the products. Order the results by product line and the descending order of the difference. (Products table)

Query 2. List product names and the product vendor for all products where the scale of the products is 1:700. (Products table) and the product line is Ships.

Query 3. List the customer name, phone number and credit limit for customers whose credit limit is less than 50,000 or greater than 200,000 and are from either the USA, France or Spain. (Customers table)

Query 4. List the first and last names of employees in 1 column with an appropriate header if the employee is a person from the sales/sale department. (Employees table)