Mysql and scripts exams
Hello, Someone expert in mysql, could you help me in exams? I am willing to give money for it if you assure me that I will approve ^^
mp for me
+++++++++++++++++
an example of some exercises, translators by google ... forgive xD
they are only selections and consultations
6. From the BILLS table, view the invoice number, the name of the product, the unit price and the ordered units of the rows whose invoice number
Odd sea, ordered ascending by invoice number. Track: Function
Mod or Operator%.
7. From the BILLS table, view the invoice number, the name of the product, the unit price of the rows whose invoice number is even, ordered
Descending by invoice number and displaying a new column
with the value of the square root invoice number and with the alias "Root" rounded to two decimals. Track: Round and Sqrt functions.
8. From the BILLS table, view the date of the invoice, the product and the units of the rows of people in the units divisible by 12, ordered
Descending by the invoice date column.
9. From the BILLS table, visualize the units of the rows of rows in the number of units less than 10, also displaying a new column
with the value of the units raised in the cube and with the alias Unid. to the cube. Hint: Pow function.
10.From the INVOICES table display the invoice number, the units, the difference between the invoice number and the units with the alias VAL_SIGNO and the
absolute value of the difference between the invoice number and the units with the
alias VAL_ABSOLUTO of those rows where the number of units exceeds
Double the invoice number. Track: Abs function.
11.From the EMPLOYEES table display the columns of the value of the difference between DIETS and COMMISSION with the alias "Difference", the absolute value of the difference between DIETS and COMMISSION with the alias "Absolute", the value of the sign of
The difference between DIETS and COMMISSION with the alias "Sign" and finally the value of the sum of SALARY, DIETS and COMMISSION with the alias "Total". Track
Function sign.
mp for me
+++++++++++++++++
an example of some exercises, translators by google ... forgive xD
they are only selections and consultations
6. From the BILLS table, view the invoice number, the name of the product, the unit price and the ordered units of the rows whose invoice number
Odd sea, ordered ascending by invoice number. Track: Function
Mod or Operator%.
7. From the BILLS table, view the invoice number, the name of the product, the unit price of the rows whose invoice number is even, ordered
Descending by invoice number and displaying a new column
with the value of the square root invoice number and with the alias "Root" rounded to two decimals. Track: Round and Sqrt functions.
8. From the BILLS table, view the date of the invoice, the product and the units of the rows of people in the units divisible by 12, ordered
Descending by the invoice date column.
9. From the BILLS table, visualize the units of the rows of rows in the number of units less than 10, also displaying a new column
with the value of the units raised in the cube and with the alias Unid. to the cube. Hint: Pow function.
10.From the INVOICES table display the invoice number, the units, the difference between the invoice number and the units with the alias VAL_SIGNO and the
absolute value of the difference between the invoice number and the units with the
alias VAL_ABSOLUTO of those rows where the number of units exceeds
Double the invoice number. Track: Abs function.
11.From the EMPLOYEES table display the columns of the value of the difference between DIETS and COMMISSION with the alias "Difference", the absolute value of the difference between DIETS and COMMISSION with the alias "Absolute", the value of the sign of
The difference between DIETS and COMMISSION with the alias "Sign" and finally the value of the sum of SALARY, DIETS and COMMISSION with the alias "Total". Track
Function sign.
Originally Posted by Allura
