Question: SQLs: Write down SQL statements to , 1 . Create the above mentioned Employees Table. 2 . Insert the records shown above. 3 . Show

SQLs: Write down SQL statements to,
1. Create the above mentioned Employees Table.
2. Insert the records shown above.
3. Show all the records (all the columns and all the rows) as output.
4. Show the DISTINCT department names of this office.
5. Show all the employees hired after 2022-12-31.
6. Show all the information of the employees whose salary is higher than 80000.
7. Show all the information of the employees whose salary is less than 75000.
8. Show all the information of the employees whose salary is between 80000 and 90000.
9. Show all the information of the employees who are from Sales department.
10. Show first name of the employees who are from Sales department and salary is higher
than 75000.
SQLs: Write down SQL statements to, 1. Create the above mentioned

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

please help with these first three. thank you INSTRUCTIONS : Please read through every instruction and question well. Answer all questions on the answer sheet provided, and turn in the question paper...

Q:

Answers below questions by writing SQL statements and with screen prints where mentioned. Create table name stating with your Campus ID. Example AX23456_TableName T_Customer_22 Customerld PK TO First...

Q:

WiL Activity 5: Write SQL for a TV Guide Module 1: Design a database schema to hold information for a TV guide. Call the database TVGuide. Each TV show must have a title, a description, a...

Q:

ATTENTION: THIS NEEDS TO BE DONE IN PHPMYADMIN. PLEASE CONFIGURE IT TO THAT AND ADD SCREENSHOTS*************** Consider the following database. Employee has a unique eid, name, age and salary....

Q:

Write SQL for a TV Guide Module 1: Design a database schema to hold information for a TV guide. Call the database TVGuide. Each TV show must have a title, a description, a classification (G, PG, M,...

Q:

The goal of this database is to connect students who need a ride to a vaccination site with sites that have vaccines available using RIT owned cars driven by RIT employees. To obtain we need to...

Q:

1. Write the SQL statements to ereate database objects. la. Create a table with the details shown below: Table-Name: Doctors_Student_id [Example Doctors_12.J124] \begin{tabular}{|1|1|1|} \hline...

Q:

1. Write the SQL statements to ereate database objects. la. Create a table with the details shown below: Table-Name: Doctors_Student_id [Example Doctors_12.J124] \begin{tabular}{|1|1|1|} \hline...

Q:

1. Write the SQL statements to ereate database objects. la. Create a table with the details shown below: Table-Name: Doctors_Student_id [Example Doctors_12.J124] \begin{tabular}{|1|1|1|} \hline...

Q:

I. Write the SQL statements to create database objects. la. Create a table with the details shown below: [2.5 Marks ] Table-Name: Doctors_Student_id [Example Doctors_123124] \begin{tabular}{|1|1|1|}...

Q:

5.In a nut shell, when you look back over time, the power of image has always been there. Even in the prehistoric era, they used imagery to communicate, and what's even more incredible is that we are...

Q:

Most business are forced to evaluate opportunities for capital investments to allocate scarce funds. While there are many ways to evaluate the wisdom of a capital investment, one such way is to do so...

Q:

b) To compute the amount of money in the savings account at the end of 1 year, take the original value and add interest: $ 2500 plus 2.8 % times $ 2500. This is equivalent to multiplying $2500 by...

Q:

Find the radius of gyration of a plate covering the region bounded by x=3, x=5, y=0, and y=4 with respect to the y-axis.

Q:

(Appendices) PURCHASES, PURCHASE RETURNS, AND PAYMENT FOR PURCHASES. Jordan Footwear sells athletic shoes. During April Jordan made the following purchases on credit with terms 3/15, n/40: LO4 Assume...

Q:

(Appendices) A CLASSIFIED INCOME STATEMENT FOR A MERCHANDISING BUSINESS. For each of the cases presented below, compute the missing amounts: LO8

Q:

(Appendices) PURCHASES, TRANSPORTATION-IN, AND PURCHASE RETURNS. Alpharack Company sells a line of tennis equipment to retailers. Alpharack uses periodic inventory accounting. Alpharack engaged in...