Part B of Assignment 3(SQL)

Steps to publish the report in Part A-

• Create 2 tables in the excel sheet with 2 different entities
  
• Go to www.db.zoho.com
• Choose import.xls or any of the remaining 3 options available
  
• Name the database
  
• Select data from each tables created in the excel sheet
• Press the create button(run it for each table)
• Now select new query table and type in the first query and save the same(do it for the remaining querries as well)
• Click on the view mode
  
• Run the publish tab and embed the same on the website for each querry
• A url will be generated
• Copied and posted at my blogg
• Publish the report

The queries that i have used are

• Table 1
  

SELECT "Last Name", "First Name" FROM "Student" where "Mess ID" like 'zaw'

• Table 2

SELECT "Last Name","First Name" From "Student" where "Fees/mth">=1500

• Table 3

SELECT "ID","Join Date","Fees/mth","Mess ID" from "Student", "Mess" where "Student"."Mess ID" = "Mess"."Mess ID"