Download sql script file sailors.txt Create and populate those tables Try the following queries: Q1, Q12, Q21, Q26, Q31,

1 / 3

# Download sql script file sailors.txt Create and populate those tables Try the following queries: Q1, Q12, Q21, Q26, Q31, - PowerPoint PPT Presentation

Download sql script file sailors.txt Create and populate those tables Try the following queries: Q1, Q12, Q21, Q26, Q31, Q32 . stime. ename. dname. eid. salary. Employee. workin. Lab Exercise 1. Employee int, varchar2(20), decimal(10,2) 22,'Dustin',10000.0 23,'Bob',15000.0

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'Download sql script file sailors.txt Create and populate those tables Try the following queries: Q1, Q12, Q21, Q26, Q31,' - zerlina

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
• Create and populate those tables
• Try the following queries:
• Q1, Q12, Q21, Q26, Q31, Q32

stime

ename

dname

eid

salary

Employee

workin

Lab Exercise 1

Employee

int, varchar2(20), decimal(10,2)

22,'Dustin',10000.0

23,'Bob',15000.0

24, 'Dustin',20000.0

Department

101,'cs','keenedy‘

102,'ee','smith‘

Workin

int, int, date

22,101,'10-OCT-98‘

22,102, '10-JAN-99‘

23,102,'15-OCT-98’

24,101, '10-OCT-01‘

did

Department

• Map ER to relation tables
• Populate table
• Q1 “find the name of employees who work at cs dept”
• Q2 “find the name of emplyees who have not worked at dept 101”
Lab 2

Q3 “find the average salary of employees”

Q4 “find the average salary of employees for each dept.”

Q5 ”Find the average salary of employes for each department that has at least 3 SUCH employees”

Q6 “find the average salary of employees whose salary is above 9000” for each department that has at least three SUCH employees.

Employee

3,‘Alice',8000.0

4,‘Mike',7000.0

5, ‘Alex',10000.0

6,’David’,20000.0

Department

103,‘sis',‘carc‘

Workin

3,103,'10-OCT-00‘

4,103, '10-JAN-00‘

5,103,'15-OCT-00’

6,102, '10-OCT-01‘