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