SQLTeam.com | Weblogs | Forums

SQL 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 :slight_smile:

Please note that this is a SQL Server forum. Your q is not for SQL Server but some other dbms. That's ok, just be aware that many people here will not be familiar with other dbms's.

1 Like