Common SQL operations:
filter: where gender = F
where gender = F
projection: select first_name, last_name from ...
select first_name, last_name from ...
join: select ... from employee t1, salary t2 where t1.emp_id = t2.id
select ... from employee t1, salary t2 where t1.emp_id = t2.id
aggregation: select count(*) from ... group by gender
select count(*) from ... group by gender
Last updated 5 years ago
