SQL Assignment 3-Part B

STEPS TO EXECUTE SQL QUERY

STEP 1: Go to http://db.zoho.com and create a user ID
STEP 2: Create a table on an Excel Sheet. For Example: - It may include data like Serial Number, Name of the Customer, Brand, etc.
STEP 3: Sign in to http://db.zoho.com
STEP 4: Create a database by importing data directly from the Excel Sheet created
STEP 5: Run a query using SQL. For Example: - 3 queries were ran and were saved separately
• Query 1
SELECT "Sl. No.", "Name of the Customer", "Items Bought" FROM "Untitled-1"
• Query 2
SELECT "Sl. No.", "Name of the Customer", "Items Bought" FROM "Untitled-1" where "Quantity">2
• Query 3
SELECT "Sl. No.", "Name of the Customer", "Items Bought", "Brand", "Quantity" FROM "Untitled-1" where "Sl. No." > 7
STEP 6: Publish the following query tables on a blog