SQLTeam.com | Weblogs | Forums

SQL query question help

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
FROM softwarelicenses;
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

Reposting a question is not appropriate. Please remove this copy.

1 Like

I reposted the question as I was told I posted it under the wrong topic previously.