$1.$ Write code to provide a list of clients that purchased the brand Bare Escentuals

$2.$ Write code to provide three lists.

a$.$ One list of distinct clients that purchased from only the online channel

and not the store channel.

b$.$ One list of distinct clients that purchase from only the store channel and

not online

c$.$ One list of distinct clients that purchased from both the online and store

channel.

$3.$ Write code to provide the count of distinct clients, total orders, total sales, and

average basket $($i$.$e$.$ transaction size$)$ by purchase channel

$4.$ Write code to provide a list of distinct clients that have an email address, signed

up for BI after $01/01/2010,$ and purchased mascara after $3/10/2010$

$5.$ Write code to provide a list of every email address and each email address$$ total

sales.