Write a SQL statement that will list for each customer whose billing address is on a...

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

Answer The code is as follow SELECT cfirstn... View the full answer