Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
subject: I can't figure out what I am doing wrong. table:
subject: homework help
I have this homework problem that I am recieving an error on. I can't figure out what I am doing wrong.
table:
+--------------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+---------------+------+-----+---------+----------------+
| order_id | int(11) | NO | PRI | NULL | auto_increment |
| customer_id | int(11) | NO | MUL | NULL | |
| order_date | datetime | NO | | NULL | |
| ship_amount | decimal(10,2) | NO | | NULL | |
| tax_amount | decimal(10,2) | NO | | NULL | |
| ship_date | datetime | YES | | NULL | |
| ship_address_id | int(11) | NO | | NULL | |
| card_type | varchar(50) | NO | | NULL | |
| card_number | char(16) | NO | | NULL | |
| card_expires | char(7) | NO | | NULL | |
| billing_address_id | int(11) | NO | | NULL | |
+--------------------+---------------+------+-----+---------+----------------+
question:
a SELECT statement that returns these columns from the Orders table:
--