คำถามคะ
1.show product name and new cost including vat7% that have been ordered
in the first half of month
--->
2.show customers that order products between 15-Jan-2005 and 5-May-2005
and sales_id odd number only including order date with format like DD-MON-YYYY.
---> select custommer_id
3.show product id,product code,product name,group code and lowest cost of
product with the highest average cost.
--->
4.show all customers that have been order on the same day on
which the maximum number of customers has been ordered.
--->
5.Give the result below. find the solution, if order date is birstday.
Customer_code Customer_name Birthday
8143658842 Amina collection April 10
6653442726 Nattida May 10
6653442726 Nattida May 10
--->
6.Given a sentence 'Tester is my job'. How to print a word as 'Tester!!!' on screen
--->
ข้อมูอที่ใช้เขียน
Load balance : Server 05
