select * from student

select name studentname,tot_cred from student 
where lower(name) like 't%'

select * from 
(select i.*, a.* from instructor i 
left join advisor a on i.id = a.i_id) T 
where i_id is null