Hi guys, I’m back! I have some good news to yah. Classes are over and it’s summer time! :))))))))))
I’ll be posting some of my programming problems at the same time the SQL codes and its output. 😉
OH by the way, congratulations to Class 2014 especially to my sister. Just graduated last March 22,2014 (BSBA-MA), and of course to my lil’ brother who will be graduating this coming March 27, 2014 (Grade 6). Me? Well not today or this year, but sooooooooonnest. haha 🙂
I just want to clarify that I don’t have the copy of the tables of this problem. Our professor just provided it to us and we answered it right away. So let’s start shall we? 🙂
PS: I was assigned to answer EVEN NUMBERS ONLY.
Query2. Find the customer name, address, city and pincode for the client who has placed order no “019001”.
SELECT [ClientName], City, State, PincodeFROM Client, SalesOrder WHERE Client.Clientno=SalesOrder.Clientno And SalesOrder.[SOrderNo]='019001'; Output:
Query4. Find out if product “1.44 Drive” is ordered by only client and print the client_no name to whom it was sold.
SELECT ClientNo FROM SalesOrder WHERE `SOrderNo` = (SELECT `SOrderNo` FROM `SalesOrderDetail` WHERE ProductNo= (SELECT ProductNo FROM Product WHERE Description="1.44 Drive")); Output:
Query8. Select the names of persons who are in Mr. Pradeep’s department and who have also worked on an inventory control system.
SELECT ClientName as 'Name' FROM Client WHERE Client.City = 'Bombay' UNION ALL SELECT `Salesmanname` as 'Name' FROM SalesTable WHERE SalesTable.City = 'Bombay'; Output:
Query10. Select the product_no, description, qty_on_hand, cost_price of non-moving items in the product_master_table.
SELECT ProductNo, Description, `Qty_on-hand`, CostPrice FROM Product WHERE Product.Description = 'Monitors' OR Product.Description = 'Mouse' OR Product.Description = 'Keyboards'; Output:
Part 1 is now all set and of course I’ll be posting also the part 2 and part 3 of this problem. Since, it has 3 sets of problems. 🙂
If there’s anything wrong of my codes, just message me up and make it right…