Question: PLEASE HELP ME!! USING THIS TABLE PLEASE DO 10.1 AND 10.2 ASAP AND PLEASE READ THE INSTRUCTION Database Implementation The report must include Structured Query
PLEASE HELP ME!!
USING THIS TABLE



PLEASE DO 10.1 AND 10.2 ASAP AND PLEASE READ THE INSTRUCTION
Database Implementation The report must include Structured Query Language (SQL) commands using MySQL workbench for the following sections: 10.1. Section A: Data Definition Language (DDL) This section describes the SQL command languages and the *output for: - CREATE TABLE statement for all table structures. 10.2. Section B: Data Manipulation Language (DML) i. The SELECT statements for ALL TABLES which displayed minimum of 10 records for appropriate tables. ii. Describes the queries which consist of the: 1) questions, 2) MySQL SQL command languages and 3) output. - Queries for each lab topic: Retrieving Data from Multiple Tables (Joining Database Tables) which at least 5 queries. *Simple SQL Queries (SELECT, WHERE, ORDER BY, DISTINCT) which at least 5 queries.: - Comparison Operators (=,,==,,> ) - Logical Operators (AND, OR NOT) - Special Operators (BETWEEN, LIKE, IS NULL, IN, DISTINCT) Column Functions and Grouping (SUM, AVG, MIN, MAX, COUNT (*), COUNT (DISTINCT), GROUP BY, HAVING, ORDER BY) - at least 3 queries Using Subqueries (WHERE, HAVING, IN) - at least 3 queries
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
