1. Jika ada aggregate function pada query, query akan error jika tidak melakukan…A. HAVING aggregate function
B. Mengalias kolom aggregate
C. GROUP BY aggregate
D. GROUP BY non-aggregate
2. Manakah query tepat yang dibawah ini untuk menampilkan StaffPosistion dan jumlah dari Staff?
A. SELECT StaffPosition, COUNT(StaffPosition) AS [Position Count] FROM MsStaff GROUP BY StaffPosition
B. SELECT StaffPosition, COUNT(StaffPosition) AS [Position Count] FROM MsStaff
C. SELECT StaffPosition AS [Position Count] FROM MsStaff GROUP BY COUNT(StaffPosition)
D. SELECT StaffPosition AS [Position Count] FROM MsStaff GROUP BY COUNT(StaffPosition) AS [Position Count]
3. Manakah query tepat yang dibawah ini untuk menampilkan StaffPosistion dan jumlah dari Staff dan data akan diurutkan dari besar ke kecil(Descending) berdasarkan kolom StaffPosition?
A. SELECT StaffPosition, COUNT(StaffPosition) AS [Position Count] FROM MsStaff GROUP BY Staff Position ORDER BY StaffPosition
B. SELECT StaffPosition, COUNT(StaffPosition) AS [Position Count] FROM MsStaff GROUP BY Staff Position ORDER BY StaffPosition DESC
C. SELECT StaffPosition, COUNT(StaffPosition) AS [Position Count] FROM MsStaff GROUP BY Staff Position ORDER BY StaffPosition ASC
D. SELECT StaffPosition, COUNT(StaffPosition) AS [Position Count] FROM MsStaff GROUP BY Staff Position ORDER BY StaffPosition DESENDING
4. Untuk menghitung rata-rata dari sejumlah data, manakah query yang tepat?
A. AVERAGE
B. AVG
C. MEAN
D. MEDIAN