Question: Write a SQL statement that will list for each customer whose billing address is on a road: the customer's first name, the customer's last
Write a SQL statement that will list for each customer whose billing address is on a road: the customer's first name, the customer's last name, and how many orders the customer has placed. Use first name, last name, and numb orders for the column headings. ww www m addresses address_id INT customer_id INT line 1 VARCHAR(60) line 2 VARCHAR(60) city VARCHAR(40) > state VARCHAR(2) zip_code VARCHAR(10) phone VARCHAR(12) H disabled TINYINT(1) Indexes HO- + customers customer_id INT email_address VARCHAR(255) 1 password VARCHAR(60) 1 HH first_name VARCHAR(60). HE last_name VARCHAR(60) shipping_address_id INT billing_address_id INT Indexes I orders order_id INT customer_id INT order_date DATETIME ship_amount DECIMAL (10,2) tax_amount DECIMAL (10,2) - ship_date DATETIME ship_address_id INT O Indexes card_type VARCHAR (50) card_number CHAR(16) card_expires CHAR (7) billing_address_id INT Indexes categories category_id INT category_name VARCHAR(255) FI+ H+ order_items item_id INT order_id INT product_id INT item_price DECIMAL (10,2) discount_amount DECIMAL (10,2) quantity INT Indexes 1 products product_id INT category_id INT >product_code VARCHAR(10) product_name VARCHAR(255) description TEXT list price DECIMAL (10,2) discount_percent DECIMAL (10,2) date_added DATETIME Indexes
Step by Step Solution
3.52 Rating (159 Votes )
There are 3 Steps involved in it
Answer The code is as follow SELECT cfirstn... View full answer
Get step-by-step solutions from verified subject matter experts
