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 | Lessions | click 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 |
| 2 | CREATE 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 |
| 3 | SELECT 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 |
| 4 | SELECT 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 |
| 5 | SELECT 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 |