day05 SQL入门-合并

175. 组合两个表

select 
    p.firstName ,p.lastName ,a.city,a.state  
from 
    Person p left join Address a on p.PersonId=a.PersonId

1148. 文章浏览 I

select 
   distinct a.author_id as id
from 
    Views as v 
where
    v.author_id=viewer_id #自己浏览自己
order by 
    a.author_id 

1581. 进店却未进行过交易的顾客

select
	v.customer_id, count(*) count_no_trans
from 
	Visits as v left join Transactions t on v.visit_id=t.visit_id
where 
	 t.transaction_id is null
GROUP BY
		v.customer_id