I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.

3 Answers   Techno Solutions,

---

What is the use of floor function in sql server?

0 Answers  

---

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  

---

What do mean by xml datatype?

0 Answers  

---

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

---

Explain what are the database objects? : SQL Server Architecture

0 Answers  

---

What is the importance of three tier architecture?

0 Answers   QuestPond,

---

How to Rebuild Master database in sql server 2005.

2 Answers   Wipro,

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

0 Answers  

---

Define Check points and End Points?

1 Answers  

---

What are xml indexes?

0 Answers  

---

when would you go for denormalization? : Sql server database administration

0 Answers  

---