4 un cevabı bu olabılr mi?
Select software.Publisher,software.Title,software.Lisance
from software,Hardware,config where Hardware.Model="HP xw4300 Workstation"
and Hardware:HID=config.HID and config.SID=software.SID
4. Soru:
Select * from software where SID in( Select config.SID from hardware inner join config on config.HID=hardware.HID where hardware.Model='HP xw4300 Workstation')
5. Soru:How many copies of Microsoft Project Professional
2003 are currently installed?
Select count(*) from software inner join config on config.SID=software.SID where software.Title='Project Professional 2003'
Are there enough licenses to
acommodate this new request?
Select count(*)-(Select License from software where software.Title='Project Professional 2003') from software inner join config on config.SID=software.SID where software.Title='Project Professional 2003';
kalan lisans sayısı 0 yani lisans alamaz.
