Tài liệu đang xem: Câu truy vấn Bài 2

use KHACHHANG;
-- yc1 --
SELECT COUNT(*) AS SoLuongKhachHang FROM KhachHang;
-- yc2 --
select MAX(donGia) as ĐonGiaLonNhat from SanPham;
-- yc3 --
select MIN(soLuong) as SoLuongSanPhamThapNhat from SanPham;
-- yc4 --
SELECT SUM(soLuong) as TongSoLuong from SanPham;
-- yc5 --
SELECT count(*) AS SoHoaDonDaXuat from HoaDon 
where trangThai='Chưa thanh toán' 
and month(ngayMuaHang)=12 
and year(ngayMuaHang) =2016;
-- yc6 --
SELECT maHoaDon, count(maSanPham) as SoLoaiSanPhamDuocMua FROM HoaDonChiTiet group by maHoaDon;
-- yc7 --
SELECT HoaDon.maHoaDon, COUNT(HoaDonChiTiet.maSanPham) AS SoLoaiSanPham
FROM HoaDon
JOIN HoaDonChiTiet ON HoaDon.maHoaDon = HoaDonChiTiet.maHoaDon
GROUP BY HoaDon.maHoaDon HAVING COUNT(HoaDonChiTiet.maSanPham) >=5;
-- yc8 --
select maHoaDon, ngayMuaHang, maKhachHang from HoaDon ORDER BY ngayMuaHang DESC;