In the given question, it is asked to write a query that return product id, product name, category and product price for all the product where price is greater than 100.
It is database querry that can fetch the record from the product table in a database. As we know that the database is collection of tables where each table itself has information about a record.
Therefore, in this question, it is required to write a query that will return the product id, product price, product name, and product category for all those product whose price is greater than 100.
The query is:
SELECT ProductID, ProductName, ProductPrice, ProductCategory
FROM Products
Where (ProductPrice>100)
ORDER BY ProductPrice DESC;
The above given query will fetch the product id, product name, product price and product category of those products whose prices are greater than 100.
You can learn more about database query at
https://brainly.com/question/24443096
#SPJ4
