Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1) SELECT pacjenci.nazwisko, pacjenci.imie, concat("19",substr(pacjenci.PESEL,1,2)) AS `Rok urodzenia`, COUNT(*) AS `Liczba badań` FROM pacjenci JOIN badania ON pacjenci.PESEL = badania.PESEL JOIN rtg ON badania.Id_badanie = rtg.Id_badanie GROUP BY pacjenci.PESEL ORDER BY `Liczba badań` DESC LIMIT 1
- 2) SELECT NFZ, SUM(rtg.Cena_badania) AS `Koszty` FROM rtg JOIN badania ON rtg.Id_badanie = badania.Id_badanie JOIN pacjenci ON badania.PESEL = pacjenci.PESEL GROUP BY NFZ ORDER BY `Koszty` DESC;
- 3) SELECT plec, COUNT(*) FROM pacjenci JOIN badania ON pacjenci.PESEL = badania.PESEL GROUP BY plec;
- 4) CREATE USER 'jan'@'*' IDENTIFIED BY '123';
- 5) GRANT INSERT, UPDATE ON rtg.pacjenci TO 'jan'@'*';
- 6) REVOKE UPDATE ON rtg.pacjenci FROM 'jan'@'*';
- 7) INSERT INTO pacjenci VALUES('12345678910', 'Piątek', 'Ksawery', 'm', 'Wielkopolska');
- 8) ALTER TABLE pacjenci MODIFY COLUMN plec enum('m','k');
- 9) SELECT concat("19",LEFT(PESEL, 1),"0 - ","19",LEFT(PESEL, 1),"9"), COUNT(*) FROM pacjenci GROUP BY LEFT(PESEL, 1) + 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement