Ödev 7 Cevaplar

[AzS]

CEVAPLAR


1) SELECT ADI, SOYADI,SIFRE
FROM tblpersonel
WHERE EPOSTA='xyzs@xyz.com'

2) SELECT * FROM tblpersonel WHERE ADI LIKE '%can%'

3) UPDATE tblpersonel SET TELEFON='0216'+SUBSTRING(TELEFON,5,11)
WHERE TELEFON LIKE '0212%'

4) INSERT INTO tbldepartman(DEPARTMAN) VALUES('Pazarlama')

5) UPDATE tblpersonel SET ADI='Ali',SOYADI='Can'
WHERE TCKIMLIKNO='12345678912'

6) SELECT SUM(MAAS) FROM tblpersonel p, tblmaas m
WHERE p.personelID=m.personelID
AND m.TARIH>='2017-01-01' AND m.TARIH<='2017-12-31'
AND p.TCKIMLIKNO='12345678912'

7) SELECT p.ADI, p.SOYADI,m.MAAS, d.DEPARTMAN
FROM tblpersonel p, tblmaas m, tbldepartman d
WHERE p.personelID = m.personelID
AND p.departmanID= d.departmanID

8) SELECT d.DEPARTMAN, SUM(m.MAAS)
FROM tblmaas m, tbldepartman d, tblpersonel p
WHERE p.personelID = m.personelID
AND p.departmanID= d.departmanID
GROUP BY d.DEPARTMAN
ORDER BY SUM(MAAS) DESC

9) SELECT d.DEPARTMAN, COUNT(p.personelID) AS 'Çalışan Sayısı'
FROM tblpersonel p, tbldepartman d
WHERE p.departmanID= d.departmanID
GROUP BY d.DEPARTMAN