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
- 5435 Views
- Techno Solutions, I also Faced
- E-Mail Answers
Answer Posted / bobby
IN SQL SERVER
select * from (select
c.cust_ID,Cust_Name,product,Amount,order_Date from Customer
c join Orders o
on c.cust_Id=o.cust_ID)p where Cust_Name like 'M%'and
(datename("mm",order_Date)=datename("mm",getdate()))
and amount<100 order by order_Date desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is foreign key unique?
What is check constraint in sql server?
Explain the use of containers in ssis?
What are the main sources of data?
What are the database roles? : sql server security
Explain indexes disadvantages?
What are the various editions of sql server 2017 that are available in the market?
what is normalization? : Sql server database administration
How many replicas are maintained for each SQL Azure database?
What is merge replication?
How to throw custom exception in Stored Procedure?
List the various tools available for performance tuning?
What is triggers and its types?
How does using a separate hard drive for several database objects improves performance right away?
What is difference between standardization and normalization?
