What project has the longest time? List the name.
select name from projects order by hours desc limit 1
What are the names of the projects?
select name from projects
How many hours does A Magnetic Primer Designer have?
select hours from projects where name = 'A magnetic primer Designer'
What is the code for A Magnetic Primer Designer?
select code from projects where name = 'A magnetic primer Designer'
What Project has the Shortest time?
select name from projects order by hours limit 1