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

Black Wall

Language: Layout:
absolute service time: 0,46 sec      
edit mode |  history  | discussion
   now
1 19.11.2020 00:00:00
   to_char
1 Nov 19, 2020
   product_id sku category date price
1 101 A113M1 Mascara 23.04.2020 00:00:00 23
2 102 A212M2 Mascara 12.02.2020 00:00:00 23
3 103 A221NP2 Nail Polish 07.03.2020 00:00:00 15
4 104 A332NP2 Nail Polish 21.05.2020 00:00:00 15
5 105 A36LIPG Lipgloss 15.07.2020 00:00:00 19
   id sku upc quantity
1 111 A113M1 3445-113-545 540
2 222 A212M2 3445-212-454 230
3 333 A221NP2 3445-221-435 670
4 444 A332NP2 3445-332-003 168
5 555 A36LIPG 3445-336-347 470
   product_id sku category date price
1 101 A113M1 Mascara 23.04.2020 00:00:00 23
2 102 A212M2 Mascara 12.02.2020 00:00:00 23
   product_id sku category date price
1 101 A113M1 Mascara 23.04.2020 00:00:00 23
   category price
1 Lipgloss 19
   total records
1 5
   product_id sku category date price
1 101 A113M1 Mascara 23.04.2020 00:00:00 23
2 102 A212M2 Mascara 12.02.2020 00:00:00 23
3 105 A36LIPG Lipgloss 15.07.2020 00:00:00 19
   product_id sku category date price
1 101 A113M1 Mascara 23.04.2020 00:00:00 23
2 102 A212M2 Mascara 12.02.2020 00:00:00 23
3 103 A221NP2 Nail Polish 07.03.2020 00:00:00 15
4 104 A332NP2 Nail Polish 21.05.2020 00:00:00 15
5 105 A36LIPG Lipgloss 15.07.2020 00:00:00 19
   product_id sku category date price
1 105 A36LIPG Lipgloss 15.07.2020 00:00:00 19
   product_id sku category date price
1 101 A113M1 Mascara 23.04.2020 00:00:00 23
2 102 A212M2 Mascara 12.02.2020 00:00:00 23
3 105 A36LIPG Lipgloss 15.07.2020 00:00:00 19
   product_id sku category date price
1 101 A113M1 Mascara 23.04.2020 00:00:00 23
2 102 A212M2 Mascara 12.02.2020 00:00:00 23
3 105 A36LIPG Lipgloss 15.07.2020 00:00:00 19
   avg
1 415,6000
   sum
1 2078
   max
1 670
   min
1 168
   id upc quantity status
1 111 3445-113-545 540 stocked
2 222 3445-212-454 230 reorder
3 333 3445-221-435 670 stocked
4 444 3445-332-003 168 reorder
5 555 3445-336-347 470 stocked
   sku upc sku date
1 A113M1 3445-113-545 A113M1 23.04.2020 00:00:00
2 A212M2 3445-212-454 NULL NULL
3 A221NP2 3445-221-435 A221NP2 07.03.2020 00:00:00
4 A332NP2 3445-332-003 A332NP2 21.05.2020 00:00:00
5 A36LIPG 3445-336-347 A36LIPG 15.07.2020 00:00:00
6 NULL NULL A212M2 12.02.2020 00:00:00
   product_id sku upc
1 101 A113M1 3445-113-545
2 NULL A212M2 3445-212-454
3 103 A221NP2 3445-221-435
4 104 A332NP2 3445-332-003
5 105 A36LIPG 3445-336-347
   sku upc quantity
1 A113M1 3445-113-545 540
2 A221NP2 3445-221-435 670
3 A332NP2 3445-332-003 168
4 A36LIPG 3445-336-347 470
   product_id sku upc quantity
1 101 A113M1 3445-113-545 540
2 NULL NULL 3445-212-454 230
3 103 A221NP2 3445-221-435 670
4 104 A332NP2 3445-332-003 168
5 105 A36LIPG 3445-336-347 470