show info of all scientists.
select * from scientists
find those scientists whose name contains ‘Smith’.
select * from scientists where name like '%smith%'
Find the names of the projects that they are assigned to.
select t2.name from assignedto as t1 join projects as t2 on t1.project = t2.code join scientists as t3 on t1.scientist = t3.ssn where t3.name like '%smith%'