Home > database >  Consult a SQL,
Consult a SQL,

Time:09-22

Table 1:

ARRIVE_TIME DEPART_TIME
The 2020-09-21 7:30 2020-09-21 07:36
The 2020-09-22 7:30 2020-09-22 07:36
The 2020-09-23 7:30 2020-09-23 07:36
The 2020-09-24 7:30 2020-09-24 07:36
The 2020-09-25 7:30 2020-09-25 07:36
The 2020-09-26 7:30 2020-09-26 07:36
The 2020-09-27 7:30 2020-09-27 07:36
The 2020-09-28 7:30 2020-09-28 07:36
The 2020-09-29 7:30 2020-09-29 07:36
The 2020-09-30 7:30 2020-09-30 07:36



Table 2
GROUP_ID
1
2
3

Results:

ARRIVE_TIME DEPART_TIME GROUP_ID
The 2020-09-21 7:30 2020-09-21 07:36 1
The 2020-09-22 7:30 2020-09-22 07:36 2
The 2020-09-23 7:30 2020-09-23 07:36 3
The 2020-09-24 7:30 2020-09-24 07:36 1
The 2020-09-25 7:30 2020-09-25 07:36 2
The 2020-09-26 7:30 2020-09-26 07:36 3
The 2020-09-27 7:30 2020-09-27 07:36 1
The 2020-09-28 7:30 2020-09-28 07:36 2
The 2020-09-29 7:30 2020-09-29 07:36 3
The 2020-09-30 7:30 2020-09-30 07:36 1

CodePudding user response:

Association rules is what?

CodePudding user response:

There is no association rules

CodePudding user response:

reference 1st floor nayi_224 response:
association rules is what?
or if there are other methods?