1.Write the SQL statement to list all columns of the Product table for products costing more than $50. Order the results by product manufacturer (ProdMfg)

2.Write the SQL statement to list all columns of the Product table that contain the word Ink Jet in the product name

3.Write the SQL statement to list the order number, order date, customer number, customer name (first and last name) orders that are made by the customers living in Colorado (CO)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.