Advertisement
Mary_99

moje zadania

Oct 9th, 2019
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.45 KB | None | 0 0
  1. -SELECT DISTINCT job FROM works_on
  2. --SELECT  min(emp_no) FROM works_on
  3.  
  4. --SELECT emp_no , emp_lname
  5. --FROM employee
  6. --WHERE emp_no = (SELECT MIN(emp_no) FROM employee)
  7.  
  8. --SELECT emp_no FROM works_on
  9. --WHERE enter_date  = (SELECT MAX(enter_date) FROM works_on)
  10.  
  11. --SELECT SUM(budget) FROM Project
  12.  
  13.  --SELECT * FROM project
  14. --SELECT AVG(budget) FROM project
  15. -- WHERE budget > 100000
  16.  
  17.  
  18. --SELECT COUNT(job), job FROM works_on
  19. --GROUP BY job
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement