Where Clause on the below conditon

[Purushothaman]

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

[Bunim · Accepted solution]

load 
*
from Retail
where

(Product = 'Mobile' and Market = 'Openmarket)
or
( (Product =  'TV' or  Product = 'Fan')  and Market = 'Closedmarket')