Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select imie, nazwisko, kwota_zamowienia from klienci inner join zamowienia on klienci.ID_klient=zamowienia.klient_ID where kwota_zamowienia > 1000;
- select imie, nazwisko, kwota_zamowienia * 0.23 AS 'Podatek VAT' from klienci inner join zamowienia on klienci.ID_klient=zamowienia.klient_ID;
- select imie, nazwisko, telefon AS 'Podatek VAT' from klienci inner join zamowienia on klienci.ID_klient=zamowienia.klient_ID GROUP BY klient_id ORDER BY COUNT(*) DESC LIMIT 3;
- select klienci.*, SUM(kwota_zamowienia) AS 'suma' from klienci inner join zamowienia on klienci.ID_klient=zamowienia.klient_ID GROUP BY klient_id ORDER BY kwota_zamowienia DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement