Question

Q1. Consider the following table "EMP" and answer the following queries:
Queries are in the photograph given

Answer 1

Answer:

select * from EMP

where age <=40

select * from EMP

where sex = 'F';

select department, charges from EMP

where name like 's℅';

select department

from EMP;

select * from EMP

where sex='F' and department='orthopedic';