Instructions: Use a sample database to practice each question. Write SQL queries and include the

expected output.

$1.$ Write a query to retrieve all columns from a table named Employees where the

department is "Finance".

$2.$ Retrieve all employees whose salary is greater than $50000.$ Use the $>$ operator in your

query.

$3.$ Write a query to select employees from the Employees table where department is "Sales"

and salary is above $60000.$

$4.$ Retrieve employees from the Employees table who are in either the $"$HR$"$ or "Marketing"

department using the IN operator.

$5.$ Select all products from a Products table with prices between $100$ and $500.$

$6.$ Retrieve all customers from a Customers table where the last$\_$name starts with the letter

$"$S$".$

$7.$ Select all orders from an Orders table, sorted by order$\_$date in descending order.

$8.$ Retrieve the top $5$ highest$-$paid employees from the Employees table

$9.$ Find the total number of employees in each department from the Employees table.

$10.$ From a Sales table, calculate the total sales amount $($SUM$($sales$\_$amount$))$ for each

region.