The Data Monk is created to give you most of the “must-have” resources to make you believe that Analytics is easy and FUN.
We have more than 30 ebooks on Amazon :)
TDM = [‘The’,’Data’,’Monk]
a. Print the last object of the list
b. Change the last element to Monkey
c. Remove Monkey from the list
d. GET Monk back to the list
They did not use The Data Monk as example :P
Write an SQL Query find number of employees
according to gender whose DOB is between 01/01/1960 to
31/12/1975.
Use column name as sex,DOB table name Employees
A simple query looks something like below
Select *
FROM Table1
Left join Table 2 on (Condition)
where
group by
order by
But what is the flow of execution of commands at the back-end?