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:

—