All language subtitles for 4. Exercise 15 Date-time functions

Hi everyone
1

Now that we know about the date time functions
2

Let's try to find out the age of Batman who was born on April 6th 1939
3

I want you to find out the years months and days
4

From this date
5

In the next activity
6

You'll have to analyze and find out the monthly sales of
7

Chair subcategory
8

What I mean is
9

in the resultset I want you to get
10

the sales of
11

Chair subcategory
12

For each month
13

so your result set should have the 12 months
14

And against those 12 months it should contain the sum of
15

Sales for those 12 months for the subcategory chair in the year 2015
16

Once you have done this try to find out if there is any pattern
17

I am not sure if there is actually any pattern
18

But
19

once we run this query
20

Probably we will see
21

that in some particular season
22

chairs are sold more in some season chairs are sold less
23

once you have done this
24

You have learnt
25

the datetime function successfully