**SQL Help from Elakiri Pros**

[himalaka]

Dear SQL Pros in Elakiri

Please help me to find answers for these questions for study purpose

Using Northwind Database, write SQL statements for the following data retrieval operations.

• List out employee details, which are not living in city, that have ‘le’ character anywhere in the name of city.
  
• Display all the orders detail that have orderdate in between '1997-09-25' to '1997-12-30'.
  
• List out information about the latest order for each customer.

 

[Challenger SRT8]

Assignment ekak deepuwama thaniyama karapan

 

[nalinsen]

Dear SQL Pros in Elakiri

Please help me to find answers for these questions for study purpose

Using Northwind Database, write SQL statements for the following data retrieval operations.

• List out employee details, which are not living in city, that have ‘le’ character anywhere in the name of city.
  
  Select * From Table where City not like '*le*'
  
• Display all the orders detail that have orderdate in between '1997-09-25' to '1997-12-30'.
  
  Select * from Table where OrderDate between '1997-09-25' and '1997-12-30'
  
• List out information about the latest order for each customer.

ඔහොම බලන්න.

 

[windows_ubuntu]

bump

 

[himalaka]

ඔහොම බලන්න.

Thank you machan help ekata, ube dapu eken idea ekak awa... wade goda dagaththa

 

[nipunahasanka]

1
SELECT * FROM employee_details WHERE city not like '%le%'
2
SELECT * FROM order_details WHERE orderdate BETWEEN '1997-09-25' AND '1997-12-30'
3
Can't guess without database structures

1 & 2 is made with guessing common table structures.

 

[nipunahasanka]

ඔහොම බලන්න.

* => % mcn

 

[dabba1983]

Bump​