Answer the following questions then copy your code to a text document (with print screens) andupload it on Blackboard before the due date.A- Create this Employees tableDepartment_id66First namesalary1500Last nameAlmahmodAlnaserAl badrSaadSaleh1050050Abdullah200050MohammadAlabdukarem1800050AlmasoudB- Then apply the following queries:Nasser11000701- 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- Retrieve all the employees who got salary 2000$ , 10500$ or 17000$ using the IN operator5- Retrieve all the employees who got salary other than 2000$ , 10500$ or 17000$ using theIN operator6- Retrieve employee first name, last name and display his Full name which is theconcatenation of his first name and last name together.7- Retrieve the first name, last name and salary for all employees whose first name start withthe letter S.8- Retrieve the first name, last name and salary for all employees whose last name include theletter s.9- Retrieve the first name and last name for all employees whose first name consist of 4 letters.10- Retrieve the first name and last name for all employees whose first name OR last namecontains _ (underscore symbol).11- Retrieve the first_name , last_name, department_id and salary for all employees who isworking in department no 50 sorted by their salary in descending order.12- Retrieve the first_name , last_name, department_id and salary for all employees sorted bytheir department_id and their salary in descending order.13- List out the departments' numbers where employees work.

As per our guidelines we are suppose to answer only first three questions. Kindly repost other…

Answered: Answer the following questions then…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Task 8: Create the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in I_INVOICE_NUM to the date currently found in I_INVOICE_DATE.
10. Produce a list of each customer number and the third and fourth digits of his or her zipcode. The query should also display the position of the first occurrence of a 3 in thecustomer number, if it exists. SQL commands
Jump to level Complete the following statement to create a table named Country. Choose data types based on the following requirements: ISOCode3 stores the country's code, consisting of one to three letters. • IndepDate stores the country's independence date. CREATE TABLE Country ); ( ISOCode 3 /* Your code goes here */ IndepDate /* Your code goes here */ Enter a statement to delete the above table. /* Your code goes here */ ;
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…

SEE MORE QUESTIONS

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON

Computer Organization and Design MIPS Edition, Fi…

Computer Engineering

ISBN:

9780124077263

Author:

David A. Patterson, John L. Hennessy

Publisher:

Elsevier Science

Network+ Guide to Networks (MindTap Course List)

Computer Engineering

ISBN:

9781337569330

Author:

Jill West, Tamara Dean, Jean Andrews

Publisher:

Cengage Learning

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON

Computer Organization and Design MIPS Edition, Fi…

Computer Engineering

ISBN:

9780124077263

Author:

David A. Patterson, John L. Hennessy

Publisher:

Elsevier Science

Network+ Guide to Networks (MindTap Course List)

Computer Engineering

ISBN:

9781337569330

Author:

Jill West, Tamara Dean, Jean Andrews

Publisher:

Cengage Learning

Concepts of Database Management

Computer Engineering

ISBN:

9781337093422

Author:

Joy L. Starks, Philip J. Pratt, Mary Z. Last

Publisher:

Cengage Learning

Prelude to Programming

Computer Engineering

ISBN:

9780133750423

Author:

VENIT, Stewart

Publisher:

Pearson Education

Sc Business Data Communications and Networking, T…

Computer Engineering

ISBN:

9781119368830

Author:

FITZGERALD

Publisher:

WILEY

SEE MORE TEXTBOOKS