Sql Exercise 1:

Use Sql and the solmaris Condominium Group database to complete the following exercises.

• List the owner number, last name and first name of every condo owner.

• List the last name and first name of every owner who lives inbowton

• List the last name and first name of every owner who does not live in Bowton

• List the last name and first name of every owner who does not live in Bowton

Need Help With My Database Design for Product Management Queries

1. Write a query to display the customer_id,customer full name ,city,pincode,and order details (order id,order date, product class desc, product desc, subtotal(product_quantity * product_price)) for orders shipped to cities whose pin codes do not have any 0s in them. Sort the output on customer name, order date and subtotal. (52 ROWS) [NOTE: TABLE TO BE USED - online_customer, address, order_header, order_items, product, product_class]

2. Write a Query to display product id,product description,totalquantity(sum(product quantity) for a given item whose product id is 201 and which item has been bought along with it maximum no. of times. (USE SUB-QUERY) (1 ROW) [NOTE: ORDER_ITEMS TABLE, PRODUCT TABLE]

3. Write a query to display carton id, (len*width*height) as carton_vol and identify the optimum carton (carton with the least volume whose volume is greater than the total volume of all items (len * width *…