SQL - SELECT Laptops | DAILY CHALLENGE | SkillRack | ProgramID- 9985

Description:
DAILY CHALLENGE
ProgramID- 9985
SkillRack
SQL - SELECT Laptops
A table called laptop is created with the following DDL command:
CREATE TABLE laptop (id INT, name VARCHAR(30), price INT, processor VARCHAR(30), storage VARCHAR(10), ram VARCHAR(10));
Write the SQL query to select id, name, price, processor, storage, ram from the table laptop where the price is less than 40000, the processor is equal to 'Core i5', the storage is equal to '1TB' and the ram is equal to '8GB'. Note: The id of the laptops must be sorted in ascending order.