Suppose there are two tables: A Customer table and an Order table. The Order table has columns OrderID, CustomerID, OrderStatus, and TotalAmount. The Customer table has columns CustomerID, CustomerName, PhoneNumber, and Email. Write a query to print the CustomerID, CustomerName, OrderStatus, and TotalAmount, excluding the orders placed in August.

Question

Accepted Answer

Query to print CustomerID, CustomerName, OrderStatus, and TotalAmount excluding orders placed in August.

Join Customer and Order tables on CustomerID
Filter out orders placed in August using WHERE clause
Select CustomerID, CustomerName, OrderStatus, and TotalAmount columns

Accepted Answer

SELECT 
    c.CustomerID,
    c.CustomerName,
    o.OrderStatus,
    o.TotalAmount
FROM 
    Customer c
JOIN 
    Order o ON c.CustomerID = o.CustomerID
WHERE 
    EXTRACT(MONTH FROM o.OrderDate) != 8;

Accepted Answer

Select CustomerID, CustomerName, OrderStatus, and TotalAmount columns

Infosys Senior Associate Consultant interview questions & answers

Popular interview questions of Senior Associate Consultant

Top HR questions asked in Infosys Senior Associate Consultant