Show the names of editors of age 24.
select name from editor where age = 24
Please show me the names of editors of age 25.
select name from editor where age = 25
hmmm. Can you also show me the name and age of the oldest editor?
select name, age from editor where age = ( select max ( age ) from editor )
ok. can you also please give me the name and age of the youngest editor?
select name, age from editor where age = ( select min ( age ) from editor )
How many editors are older then 25 and younger than 45?
select count ( * ) from editor where age>25 and age<45
May I have their names please?
select name from editor where age>25 and age<45