The company needs a list of all software licences that have an expiry date on or before 31/12/2019.
Write an SQL query to return the fields CustomerID,
SoftwareID, LicenceType, Cost and ExpiryDate for all
licences that expire on, or before 31/12/2019.
Group the output by CustomerID, and in ascending order of cost.
CREATE TABLE softwarelicenses
SELECT CustomerID, SoftwareID, LicenceType, Cost, ExpiryDate
WHERE ExpiryDate <= #31/12/2019#)
GROUP BY CustomerID;
ORDER BY Cost ASC
So far I have this, I know it isn’t correct but any help would be much appreciated