Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -SELECT DISTINCT job FROM works_on
- --SELECT min(emp_no) FROM works_on
- --SELECT emp_no , emp_lname
- --FROM employee
- --WHERE emp_no = (SELECT MIN(emp_no) FROM employee)
- --SELECT emp_no FROM works_on
- --WHERE enter_date = (SELECT MAX(enter_date) FROM works_on)
- --SELECT SUM(budget) FROM Project
- --SELECT * FROM project
- --SELECT AVG(budget) FROM project
- -- WHERE budget > 100000
- --SELECT COUNT(job), job FROM works_on
- --GROUP BY job
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement