$-$List all fields for the customers

Select$*$ from Customers

$91$ records returned

$-$List all fields for customers who live in London

Select$*$ From customers where customers,city$=$ 'London'

$6$ records returned

$-$List all fields of suppliers from London

$-$List of all the product names and quantity$/$unit $($just display product names and quantity$)$

$-$List the current $($not discontinued$)$ products $($just display Product ID and Product name$).$ Hint:

To be current, the field discontinued equals $0.$

$-$List all of the discontinued products $($just display Product ID and Product name$).$

Hint: To be discontinued, the field discontinued equals $1.$

$-$List all employees' Last names that are tied to an order $($do not repeat the last name$)$

$-$List all employees' first name and last name in order of their hiring date. First record should be

the longest tenured employee. $($only list first and last name$)$

$-$List all employees' first and last name, customers' first and last name, and the shipping date of

an order $($only if the customer placed an order$).$

$-$List the orders for any customer that has a last name starting with the letter $"F".$ All I want is

order number.

$-$List of employees who processed the order "chai". All I want is the employee first and last

name. Hint: Although SQL is not case sensitive$,$ the values in the fields are case sensitive$.$

$-$List the suppliers that have discontinued products. All I want is company name and the product

name.

$----$please write the SQL statements for each scenario. I included a photo of the scheme to aid in completing this. Thank you so much!!