1) What AH logical operator has been used to create this result? a) supplier_id NOT BETWEEN 300 AND 600 b) GROUP BY supplier_id c) supplier_id BETWEEN 300 AND 600 d) supplier_id >= 300 AND supplier_id <= 600 e) ORDER BY supplier_id ASC f) SUM(supplier_id) 2) What H aggregate function has been used to create this result? a) SUM(*) b) MAX(supplier_id) c) No aggregate used d) COUNTA(supplier_id) e) TOTAL(supplier_id) f) COUNT(*) 3) What H grouping has been used to create this result? a) GROUP BY(supplier_id >= 300 AND supplier_id <= 600) b) GROUP BY city c) GROUP BY state d) GROUP BY COUNT(*) e) No grouping used f) GROUP BY city ASC 4) What H alias has been used to create this result? a) alias on all fields b) supplier_id c) city d) state e) no alias just field names f) COUNT(*) 5) What H sort has been used to create this result? a) ORDER BY supplierIid ASC b) no sort order c) ORDER by state DESC d) ORDER BY city DESC e) ORDER BY supplier_id ASC city DESC f) ORDER by city ASC, state DESC

AH DDD Logical Operators 2

In
Nhúng

Bảng xếp hạng

Phong cách trực quan

Tùy chọn

Chuyển đổi mẫu

Bạn có muốn khôi phục tự động lưu: không?