Create a database in MySQL A) Create a new database and import the above datasets in MYSQL.
Question:
Create a database in MySQL
A) Create a new database and import the above datasets in MYSQL.
B) Visualize the dataset in MySQL so that you can view their actual column names in the first row (You may write the names of the columns in a piece pf paper).
C) By implementing SQL queries Change col 1, col 2, col 2 to their actual column names.
D) Take screenshots of the query and the tables with their newly created columns, upload
E) From the diabetes column show the Glucose column having the entries greater than 125 and the age column having the less than 50
F) Inner join chol column of heart and BloodPressure of diabetes
G) Take BMI column of diabetes and age from heart union the columns and order them by BMI.
Take the screenshots of E, F and G queries and their outcomes and upload.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill