Untitled
unknown
plain_text
2 months ago
4.8 kB
6
Indexable
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');
Editor is loading...
Leave a Comment