在SQL Server中,一家生产企业需要一份销售报告,其中当天的销售总额超过20,000美元。应使用以下哪种查询?( )
select OrderDate,Amount from orders where sum(amount) 20000
select OrderDate,Amount from orders where sum(amount) 20000 order by OrderDate
select count(OrderDate),sum(amount) from orders group by OrderDate having sum(amount) 20000
select count(OrderDate),sum(amount) from orders group by OrderDate where sum(amount) 20000