Hi there,
For the below table, I would like to add the where clause on the below condition to table attached below;
My condition for where clause to extract the table is:
1st Condition: Product = 'Mobile' and Market = 'Openmarket
2 nd Condition: Product = 'TV', 'Fan' and Market = 'Closedmarket'.
Table Name: Retail
| Date |
Products |
Market |
Sales |
| 5/5/2022 |
Mobile |
Closed Market |
202 |
| 6/5/2022 |
Mobile |
Closed Market |
93 |
| 7/5/2022 |
Mobile |
Closed Market |
182 |
| 8/5/2022 |
Mobile |
Closed Market |
78 |
| 9/5/2022 |
Mobile |
Closed Market |
105 |
| 10/5/2022 |
Mobile |
Closed Market |
89 |
| 11/5/2022 |
Mobile |
Openmarket |
207 |
| 12/5/2022 |
Mobile |
Openmarket |
190 |
| 13/5/2022 |
Mobile |
Openmarket |
75 |
| 14/5/2022 |
Mobile |
Openmarket |
166 |
| 5/5/2022 |
TV |
Closed Market |
156 |
| 6/5/2022 |
TV |
Closed Market |
115 |
| 7/5/2022 |
TV |
Closed Market |
169 |
| 8/5/2022 |
TV |
Closed Market |
60 |
| 9/5/2022 |
TV |
Closed Market |
165 |
| 10/5/2022 |
TV |
Closed Market |
158 |
| 11/5/2022 |
TV |
Openmarket |
166 |
| 12/5/2022 |
TV |
Openmarket |
183 |
| 13/5/2022 |
TV |
Openmarket |
78 |
| 14/5/2022 |
TV |
Openmarket |
166 |
| 5/5/2022 |
Grinder |
Closed Market |
162 |
| 6/5/2022 |
Grinder |
Closed Market |
78 |
| 7/5/2022 |
Grinder |
Closed Market |
132 |
| 8/5/2022 |
Grinder |
Closed Market |
142 |
| 9/5/2022 |
Grinder |
Closed Market |
128 |
| 10/5/2022 |
Grinder |
Closed Market |
191 |
| 11/5/2022 |
Grinder |
Openmarket |
103 |
| 12/5/2022 |
Grinder |
Openmarket |
193 |
| 13/5/2022 |
Grinder |
Openmarket |
187 |
| 14/5/2022 |
Grinder |
Openmarket |
167 |
| 5/5/2022 |
Fan |
Closed Market |
178 |
| 6/5/2022 |
Fan |
Closed Market |
203 |
| 7/5/2022 |
Fan |
Closed Market |
118 |
| 8/5/2022 |
Fan |
Closed Market |
197 |
| 9/5/2022 |
Fan |
Closed Market |
135 |
| 10/5/2022 |
Fan |
Closed Market |
68 |
| 11/5/2022 |
Fan |
Openmarket |
122 |
| 12/5/2022 |
Fan |
Openmarket |
67 |
| 13/5/2022 |
Fan |
Openmarket |
69 |
| 14/5/2022 |
Fan |
Openmarket |
142 |
| 5/5/2022 |
Oven |
Closed Market |
186 |
| 6/5/2022 |
Oven |
Closed Market |
168 |
| 7/5/2022 |
Oven |
Closed Market |
114 |
| 8/5/2022 |
Oven |
Closed Market |
146 |
| 9/5/2022 |
Oven |
Closed Market |
141 |
| 10/5/2022 |
Oven |
Closed Market |
90 |
| 11/5/2022 |
Oven |
Openmarket |
188 |
| 12/5/2022 |
Oven |
Openmarket |
175 |
| 13/5/2022 |
Oven |
Openmarket |
113 |
| 14/5/2022 |
Oven |
Openmarket |
170 |
