Answer the following questions then copy your code to a text document (with print screens) and upload it on Blackboard before the due date. A- Create this Employees table salary 1500 Department_id 66 First name Last name Almahmod Alnaser Al badr Saad Saleh Abdullah Mohammad 10500 2000 50 50 Alabdukarem 18000 50 Almasoud B- Then apply the following queries: Nasser 11000 70 1- Retrieve all the employees who got salary more than 2000$ 2- Retrieve all the employees who got salary in the range 2000$ to 11000$ 3- Retrieve all the employees who got salary out of the range 2000$ to 11000$

4. Display a list of all book titles and the percentage of markup for each book. The percentageof markup should be displayed as a whole number (that is, multiplied by 100) with nodecimal position, followed by a percent sign (for example, .2793 = 28%). (The percentageof markup should reflect the difference between the retail and cost amounts as a percent ofthe cost.) SQL commands

The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name and height for only horses that have an above average height. Order the results by height (ascending).

Country ISOCode3 Name PopDensity FJI Fiji 130 CHE LTU Switzerland 560 Lithuania 120 Complete the UPDATE statement to change 'Fiji' to 'North Macedonia' in the Country table. In the WHERE clause, identify the row to be changed using the PopDensity column. UPDATE Country SET WHERE Note: Your answers for SET and WHERE should include the column names followed by an equals sign and the corresponding value.

6. Create a list of all book titles and costs. Precede each book’s cost with asterisks so that thewidth of the displayed Cost field is 12. SQL commands

The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name and height for only horses that have an above average height. Order the results by height (ascending). Hint: Use a subquery to find the average height.

Use select statements to create queries that answer the following questions. Only provide the information requested.  Do not provide the output.  All tables are provided below List the name of all bouquets that are priced at $29.99. List the customer id for all customers who ordered item 7.

Display the total number of credits earned in each year using the tot credits (year, num credits) view.

Q1. Please write SQL codes to query data from dvd table based on below criteria  Please write a SELECT statement to display different DVD title (the same title will be displayed one and only one time) and the first character of the DVD titles must be between ‘A’ and ‘L’. Please display the result in descending order (from ‘A’ to ‘L’ order). The result should be identical to below results: [screen-shot]

the employee table have the following . ask user what is the employee_id and how much employee wants to contribute 2 substitutions variable from end user &emp_id      &contribution_amount If employee salary is in between $1000-$3999 And if  employee's contribution amount is less than $100 then company match $100                   if  employee's contribution amount is greater than 100 but less than $200 then company match $75                  if  employee's contribution amount is greater than $200 then company match $50 $4000-$6999 And if  employee's contribution amount is less than $100 then company match $150                   if  employee's contribution amount is greater than 100 but less than $200 then company match $100                  if  employee's contribution amount is greater than $200 then company match $75  $7000-$12000And if  employee's contribution amount is less than $100 then company match $200                   if  employee's contribution amount is greater than…