单选题

以下hive sql语法正确的是

Question

A. select * from a inner join b on a.id&lt&gtb.id

B. select * from a where a.id in (select id from b)

C. select sum(a.amt) as total from a where a.total&gt20

D. select * from a inner join b on a.id=b.id