Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

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:

--

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question