Start MYSQL Query typing Practice. MYSQL Select Statment, MySql creating Table, Where Clause Typing Practice, MySql Alia and Sub Query statment typing Practice.Click on the area below to start typing.

S.No.Paragraph : Practice repeatedly whatever you would like most for full fifteen minutes Lessionsclick to Practice
1//Use the SELECT statement to select data from a table. SELECT lastName FROM employees; SELECT 1 + 1;// understanding select querey SELECT NOW(); //Current date and time SELECT lastName, firstName, jobTitle FROM employees; SELECT * FROM employees; SELECT CONCAT('John',' ','Doe'); SELECT CONCAT('John',' ','Doe') AS name;1.1 MySQL SELECT statement typing practice
2CREATE TABLE [IF NOT EXISTS] table_name( column_1_definition, column_2_definition,..., table_constraints ) ENGINE=storage_engine; //a example of creating tables CREATE TABLE IF NOT EXISTS tasks ( task_id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255) NOT NULL, start_date DATE, due_date DATE, status TINYINT NOT NULL, priority TINYINT NOT NULL, ) ENGINE=INNODB;1.2 MySQL CREATE TABLE statement typing practice
3SELECT select_list FROM table_name WHERE search_condition; SELECT lastname, firstname, jobtitle FROM employees WHERE jobtitle = 'Sales Rep'; SELECT firstName, lastName, officeCode FROM employees WHERE officeCode BETWEEN 1 AND 3 ORDER BY officeCode; SELECT firstName, lastName FROM employees WHERE lastName LIKE '%son' ORDER BY firstName; SELECT lastname, firstname, jobtitle FROM employees WHERE jobtitle <> 'Sales Rep';1.3 MySQL WHERE clause typing practice
4SELECT e.firstName, e.lastName FROM employees e ORDER BY e.firstName; SELECT customerName,COUNT(o.orderNumber) total FROM customers c INNER JOIN orders o ON c.customerNumber = o.customerNumber GROUP BY customerName ORDER BY total DESC; SELECT customers.customerName, COUNT(orders.orderNumber) total FROM customersINNER JOIN orders ON customers.customerNumber = orders.customerNumber GROUP BY customerName ORDER BY total DESC; SELECT orderNumber 'Order no.', SUM(priceEach * quantityOrdered) total FROM orderDetails GROUP BY 'Order no.' HAVINGtotal > 60000;1.4 MySQL Alias typing practice
5SELECT lastName, firstName FROM employees WHERE officeCode IN (SELECT officeCode FROM offices WHERE country = 'USA'); SELECT customerNumber, checkNumber, amount FROM payments WHERE amount = (SELECT MAX(amount) FROM payments); SELECT customerName FROM customers WHERE customerNumber NOT IN (SELECT DISTINCT customerNumber FROM orders); SELECT MAX(items), MIN(items), FLOOR(AVG(items)) FROM (SELECT orderNumber, COUNT(orderNumber) AS items FROM orderdetails GROUP BY orderNumber) AS lineitems;1.5 MySQL Subquery typing on typing kick