Zadanie 1




Zadanie 2

SELECT emp_no
FROM works_on
WHERE (enter_date < '2007-01-01') or (enter_date > '2007-12-31')




Zadanie 3

select emp_no, emp_lname
from employee
where emp_fname like '%t%t%'



Zadanie 4

USE dbjoin
SELECT emp_no from dbo.employee e inner join dbo.department d
ON e.dept_no=d.dept_no where d.location='Seattle'


Zadanie 5


When grouping column contains a null value, that row becomes a group in the results and if grouping column contains more than one null value, the null values are put into a single group.


Zadanie 6

COUNT(*) operation counts all rows fed to it by execution plan branch under it /// COUNT(column) operation counts all non-null values in that column from rows fed to it by execution plan branch under it


Zadanie 7

USE dbjoin
SELECT MAX(emp_no) from employee


Zadanie 8

SELECT job FROM works_on

where emp_no in (select emp_no from works_on group by

emp_no having COUNT(emp_no)>1)



Zadanie 9

SELECT emp_no, job FROM works_on w INNER JOIN project p ON w.project_no=p.project_no WHERE p.project_name='Gemini'


Zadanie 10

SELECT DISTINCT emp_fname, emp_lname FROM project p
INNER JOIN works_on w ON p.project_no=w.project_no
INNER JOIN employee e ON w.emp_no=e.emp_no
INNER JOIN department d ON e.dept_no=d.dept_no
WHERE d.dept_name='Accounting' or d.dept_name='Research'


Zadanie 11

select enter_date from works_on w inner join employee e on w.emp_no=e.emp_no where e.dept_no='d1'



Zadanie 12

select project_name from project
where project_no in (select project_no from works_on  group by project_no having COUNT(emp_no)>=2)


ZAdanie 13

SELECT emp_fname, emp_lname FROM employee e
INNER JOIN works_on d ON e.emp_no=d.emp_no
INNER JOIN project p ON d.project_no=p.project_no
WHERE p.project_name='Mercury' and d.job= 'manager'

Zadanie 14


SELECT emp_no FROM employee e
INNER JOIN department d ON e.dept_no=d.dept_no
WHERE d.dept_name='marketing'

Zadanie 15


CREATE TABLE project_temp  (project_no INTEGER NOT NULL,
                        project_name CHAR(20) NOT NULL,
                        budget CHAR(20) NOT NULL,)