Всем привет, Может кто-нибудь, пожалуйста помочь с написанием данных запросов?
1) How many persons with Title = 'Mr' [1] have 'PM' type [ContactType] of the contract [BC]
2) Find all Email for which ModDate is greater than the current (TRY NOT TO USE [> "YYYY-MM-DD"] format )
3) Find and return the list of Modals [3] greater than average
4) Find addresses [Adresses] that are not associated with any client [Person]. Return [Address] and [AddressID] from the table [Adresses].

Думаю, что так, но не уверен:
1) SELECT COUNT T=Mr FROM 1 WHERE дальше не идет в голову
2) Не знаю
3) Select Modals FROM 3 WHERE Modals>AVG
4) SELECT * FROM Adresses WHERE NOT * = 'что-то'. Select Address, AddressID * FROM Adresses