# SQL Test Question

**URL:** <https://forum.kirupa.com/t/sql-test-question/183480>\
**Category:** programming\
**Created:** [March 27, 2006, 2:00pm UTC](https://forum.kirupa.com/t/sql-test-question/183480 "2006-03-27T14:00:10Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![SlowRoasted](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@SlowRoasted](https://forum.kirupa.com/u/SlowRoasted)\
**Post date:** [March 27, 2006, 2:00pm UTC](https://forum.kirupa.com/t/sql-test-question/183480/1 "2006-03-27T14:00:10Z")

</div>

No this isn’t for school so don’t think I’m cheating.

Any help would be greatly appreciated.

The CEO comes in and asks you for a report that shows the number of orders and total amount for Perez’s Moes restaurant in the month of December. Using the following table fields to create a series of or one SQL statement that would give you the information required.

Restaurant  
RestaurantID  
Restaurant  
Address  
City  
State

Orders  
OrderID  
RestaurantID  
OrderDate  
OrderTime  
OrderAmount

OrderDetail  
OrderDetailID  
OrderID  
ItemID  
ItemAmount

I had something like this

```php

Display all the orders from December

SELECT * FROM Orders WHERE (RestaurantID = ‘Perez’) AND (OrderDate < ‘2006-01-01’) AND (OrderDate > ‘2005-11-30’)

Display the total number of orders in December

SELECT SUM(OrderAmount) From Orders WHERE (RestaurantID = ‘Perez’) AND (OrderDate < ‘2006-01-01’) AND (OrderDate > ‘2005-11-30’)

```

But Im assuming the the restaurantid is perez, which it may not be. How do you set a variable in SQL? If I had php it would be no problem.

---

<div class="post-metadata">

**Author:** ![bwh2](https://avatars.discourse-cdn.com/v4/letter/b/8c91f0/32.png) [@bwh2](https://forum.kirupa.com/u/bwh2)\
**Post date:** [March 27, 2006, 4:07pm UTC](https://forum.kirupa.com/t/sql-test-question/183480/2 "2006-03-27T16:07:31Z")

</div>

well, you’ve got duplicate field names in your first table. so i would assume that one of them is for the restaurant name. restaurant ID is probably an integer. can you do a select count(OrderAmount) in mysql? i know you can in tsql, but i would look into it for mysql.

---

<div class="post-metadata">

**Author:** ![955](https://avatars.discourse-cdn.com/v4/letter/9/4bbf92/32.png) [@955](https://forum.kirupa.com/u/955)\
**Post date:** [March 27, 2006, 4:13pm UTC](https://forum.kirupa.com/t/sql-test-question/183480/3 "2006-03-27T16:13:51Z")

</div>

You could do something like this:

```auto

SELECT SUM(Orders.OrderAmount) FROM Orders, Restaurant
WHERE Orders.RestaurantID = Restaurant.RestaurantID
AND Restaurant.Restaurant = 'Perez'
AND Orders.OrderDate > '2005-11-30'
AND Orders.OrderDate < '2006-01-01'

```

May or may not work, but that’s what I’d do 🙂

---

<div class="post-metadata">

**Author:** ![SlowRoasted](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@SlowRoasted](https://forum.kirupa.com/u/SlowRoasted)\
**Post date:** [March 27, 2006, 4:19pm UTC](https://forum.kirupa.com/t/sql-test-question/183480/4 "2006-03-27T16:19:22Z")

</div>

thx, it doesn’t specify what type of database is being used.

---

<div class="post-metadata">

**Author:** ![bwh2](https://avatars.discourse-cdn.com/v4/letter/b/8c91f0/32.png) [@bwh2](https://forum.kirupa.com/u/bwh2)\
**Post date:** [March 27, 2006, 5:11pm UTC](https://forum.kirupa.com/t/sql-test-question/183480/5 "2006-03-27T17:11:47Z")

</div>

[http://www.w3schools.com/sql/sql\_functions.asp](http://www.w3schools.com/sql/sql_functions.asp)

---

<div class="post-metadata">

**Author:** ![SlowRoasted](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@SlowRoasted](https://forum.kirupa.com/u/SlowRoasted)\
**Post date:** [March 27, 2006, 5:16pm UTC](https://forum.kirupa.com/t/sql-test-question/183480/6 "2006-03-27T17:16:44Z")

</div>

Thanks, that’s a good reference.