Untitled

SELECT 
    M.mijoz_id, 
    M.ism, 
    M.familiya, 
    M.telefon AS mijoz_telefon, 
    U.uy_id, 
    U.manzil AS uy_manzil, 
    U.narx, 
    B.bitim_id, 
    B.bitim_sanasi, 
    B.tolov_turi, 
    B.summa
FROM Bitimlar B
INNER JOIN Uylar U ON B.uy_id = U.uy_id
INNER JOIN Mijozlar M ON B.telefon = M.telefon;




SELECT 
    M.mijoz_id, 
    M.ism, 
    M.familiya, 
    M.telefon AS mijoz_telefon, 
    U.uy_id, 
    U.manzil AS uy_manzil, 
    U.narx, 
    B.bitim_id, 
    B.bitim_sanasi, 
    B.tolov_turi, 
    B.summa
FROM Mijozlar M
LEFT JOIN Bitimlar B ON M.telefon = B.telefon
LEFT JOIN Uylar U ON B.uy_id = U.uy_id;


SELECT 
    M.mijoz_id, 
    M.ism, 
    M.familiya, 
    M.telefon AS mijoz_telefon, 
    U.uy_id, 
    U.manzil AS uy_manzil, 
    U.narx, 
    B.bitim_id, 
    B.bitim_sanasi, 
    B.tolov_turi, 
    B.summa
FROM Mijozlar M
RIGHT JOIN Bitimlar B ON M.telefon = B.telefon
RIGHT JOIN Uylar U ON B.uy_id = U.uy_id;



SELECT 
    M.mijoz_id, 
    M.ism, 
    M.familiya, 
    M.telefon AS mijoz_telefon, 
    U.uy_id, 
    U.manzil AS uy_manzil, 
    U.narx, 
    B.bitim_id, 
    B.bitim_sanasi, 
    B.tolov_turi, 
    B.summa
FROM Mijozlar M
FULL JOIN Bitimlar B ON M.telefon = B.telefon
FULL JOIN Uylar U ON B.uy_id = U.uy_id;



SELECT 
    M.mijoz_id, 
    M.ism, 
    M.familiya, 
    M.telefon AS mijoz_telefon, 
    U.uy_id, 
    U.manzil AS uy_manzil, 
    U.narx, 
    B.bitim_id, 
    B.bitim_sanasi, 
    B.tolov_turi, 
    B.summa
FROM Mijozlar M
CROSS JOIN Bitimlar B
CROSS JOIN Uylar U;






SELECT 
    M.mijoz_id, 
    M.ism, 
    M.familiya, 
    M.yosh, 
    B.bitim_id, 
    B.bitim_sanasi, 
    B.summa
FROM Mijozlar M
JOIN Bitimlar B ON M.telefon = B.telefon
WHERE M.yosh > 30;


SELECT 
    U.uy_id, 
    U.manzil, 
    U.xona_soni, 
    U.narx, 
    B.bitim_sanasi, 
    B.summa
FROM Uylar U
JOIN Bitimlar B ON U.uy_id = B.uy_id
WHERE U.xona_soni >= 3;


SELECT 
    B.bitim_id, 
    B.bitim_sanasi, 
    B.summa, 
    B.tolov_turi, 
    M.ism, 
    M.familiya
FROM Bitimlar B
JOIN Mijozlar M ON B.telefon = M.telefon
WHERE B.tolov_turi = 'Naqd';



SELECT 
    U.uy_id, 
    U.manzil, 
    U.narx, 
    B.bitim_id, 
    B.bitim_sanasi, 
    B.summa
FROM Uylar U
JOIN Bitimlar B ON U.uy_id = B.uy_id
WHERE U.narx > 100000;


SELECT 
    B.bitim_id, 
    B.bitim_sanasi, 
    B.summa, 
    M.ism, 
    M.familiya, 
    U.manzil
FROM Bitimlar B
JOIN Mijozlar M ON B.telefon = M.telefon
JOIN Uylar U ON B.uy_id = U.uy_id
WHERE B.bitim_sanasi BETWEEN '2023-01-01' AND '2023-12-31';


SELECT 
    U.uy_id, 
    U.manzil, 
    U.narx, 
    U.maydon, 
    U.xona_soni
FROM Uylar U
WHERE U.narx > 50000 AND U.maydon > 50;


SELECT 
    mijoz_id, ism, familiya, yosh, manzil, telefon
FROM Mijozlar
WHERE yosh > 25 AND manzil LIKE '%Toshkent%';



SELECT 
    uy_id, manzil, maydon, xona_soni, narx, uy_turi, sotuv_holati
FROM Uylar
WHERE narx > 50000 AND sotuv_holati = 'Sotildi';


SELECT 
    mijoz_id, ism, familiya, telefon, jins
FROM Mijozlar
WHERE telefon LIKE '+998%' AND jins = 'Erkak';


SELECT 
    mijoz_id, ism, familiya, yosh, manzil, telefon
FROM Mijozlar
WHERE yosh > 30 OR manzil LIKE '%Toshkent%';



SELECT 
    uy_id, manzil, maydon, xona_soni, narx, uy_turi, sotuv_holati
FROM Uylar
WHERE narx > 50000 OR xona_soni = 3;



SELECT 
    mijoz_id, ism, familiya, telefon, jins
FROM Mijozlar
WHERE telefon LIKE '+998%' OR jins = 'Ayol';


SELECT 
    bitim_id, xaridor_ismi, tolov_turi, holati, summa
FROM Bitimlar
WHERE tolov_turi = 'Plastik' OR holati = 'Jarayonda';



SELECT 
    mijoz_id, ism, familiya, yosh, manzil, telefon
FROM Mijozlar
WHERE NOT yosh < 30;


SELECT 
    uy_id, manzil, maydon, xona_soni, narx, uy_turi, sotuv_holati
FROM Uylar
WHERE NOT xona_soni < 3;



SELECT 
    bitim_id, xaridor_ismi, tolov_turi, summa
FROM Bitimlar
WHERE NOT summa < 100000;


SELECT 
    Bitimlar.bitim_id, Bitimlar.xaridor_ismi, Bitimlar.tolov_turi, Bitimlar.summa
FROM Bitimlar
JOIN Uylar ON Bitimlar.uy_id = Uylar.uy_id
WHERE Bitimlar.summa > 50000 
    OR Bitimlar.tolov_turi = 'Naqd';


SELECT 
    Uylar.uy_id, Uylar.manzil, Uylar.xona_soni, Uylar.sotuv_holati
FROM Uylar
WHERE NOT Uylar.sotuv_holati = 'Sotilgan' 
    AND Uylar.xona_soni = 4;


SELECT 
    Bitimlar.bitim_id, Bitimlar.xaridor_ismi, Bitimlar.summa, Bitimlar.tolov_turi, Uylar.sotuv_holati
FROM Bitimlar
JOIN Uylar ON Bitimlar.uy_id = Uylar.uy_id
WHERE NOT Uylar.sotuv_holati = 'Sotilgan' 
    AND (Bitimlar.summa > 80000 
        OR Bitimlar.tolov_turi = 'Naqd');