Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose the following database Organization containing the below three tables: work ID 1 2 Bonus BONUS DATE 2/20/2016 000 6112016 000 2/20/2016 000 2/20/2015 0.00

image text in transcribed
image text in transcribed
Suppose the following database Organization containing the below three tables: work ID 1 2 Bonus BONUS DATE 2/20/2016 000 6112016 000 2/20/2016 000 2/20/2015 0.00 6/11/2016 0.00 BONUS. AMOUN 5000 3000 4000 Worker name salary Department Monica Arora 100000 Niharika Verma 80000 Admin Vishal Singhal 300000 HR Amitabh Singh 500000 Admin Vivek Bhati 500000 Admin Vipul Diwan 200000 Account Satish Kumar 75000 Account Getika Chauhan 90000 Admin 3 3 1 4 4500 5 2 3500 7 B wa 1 2 3 Title AFFECTED FRO Manager 2/20/2016 0.00 Executive 6/11/2016 000 Executive 6/11/2016 000 Manager 6/11/20160.00 Asst Manager 6.11.2016 0:00 Executive 6/11/2016 000 Lead 6/11/2016 0:00 Lead 6/11/2016 0:00 5 4 7 6 3 Write the SQL Query to: A- Prepare the Database, create and fill the tables 1 - Create the organization database 2- Create the worker / Bonus / Title tables 3- Insert some data in the worker / Bonus / Title tables. B- Simple SQL Queries: 1- Write an SQL query to fetch "FIRST_NAME" from Worker table using the alias name as . 2-Write an SQL query that display the department name fro worker table (do not repeat the values). 3- Write an SQL query to print all Worker details from the Worker table order by FIRST_NAME Ascending. 4- Write an SQL query to print all Worker details from the Worker table order by FIRST_NAME Ascending and DEPARTMENT Descending. 5- Write an SQL query to print details for Workers with the first name as "Vipul" and "Satish" from Worker table. 6- Write an SQL query to print details of workers excluding first names, "Vipul" and "Satish" from Worker table. 7- Write an SQL query to print details of workers with DEPARTMENT name as "Admin". 8- Write an SQL query to print details of the Workers whose FIRST_NAME contains a'. 9- Write an SQL query to print details of the Workers whose FIRST_NAME ends with 'a'. 10- Write an SQL query to print details of the workers whose FIRST_NAME ends with 'h' and contains six alphabets. 11- Write an SQL query to fetch the count of employees working in the department 'Admin'. 12- Write an SOL query to fetch worker first names with salaries >= 50000 and

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Medical Image Databases

Authors: Stephen T.C. Wong

1st Edition

1461375398, 978-1461375395

More Books

Students also viewed these Databases questions