WPM
100
CPM
100
Errors
0
Time
15Min
Accuracy
100%
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 | 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 |