Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Task2_Final

Language: Layout:
View schema
Execution time: 0,09 sec, rows selected: 20, rows affected: 40, absolute service time: 0,3 sec, absolute service time: 0,3 sec 
edit mode |  history  | discussion
   ProductID OrderID ProductPrice Quantity
1 1 1 500,0000 10
2 2 2 15,5000 4
3 3 3 2,5000 20
4 4 4 30,0000 7
   DWID OrderID ProductID DateID ProductPrice SellingPrice Quantity
1 1 1 1 1 500,0000 20000,0000 10
2 2 1 1 2 500,0000 20000,0000 10
3 3 1 1 3 500,0000 20000,0000 10
4 4 1 1 4 500,0000 20000,0000 10
5 5 2 2 1 15,5000 248,0000 4
6 6 2 2 2 15,5000 248,0000 4
7 7 2 2 3 15,5000 248,0000 4
8 8 2 2 4 15,5000 248,0000 4
9 9 3 3 1 2,5000 200,0000 20
10 10 3 3 2 2,5000 200,0000 20
11 11 3 3 3 2,5000 200,0000 20
12 12 3 3 4 2,5000 200,0000 20
13 13 4 4 1 30,0000 840,0000 7
14 14 4 4 2 30,0000 840,0000 7
15 15 4 4 3 30,0000 840,0000 7
16 16 4 4 4 30,0000 840,0000 7