Sql/mysql Statement instances (updated ...)

The data structure of table T_alibaba_data is as follows:

The meanings of each column are:

User ID (user_id), Brand ID (brand_id), user behavior (type, where the click is 0, purchase is 1, add to 2, add to Cart 3), the time of the Act (visit_datetime) is generated.

First, use an SQL statement to find the user who clicked on the Hot Brands (TOP10)

Select distinct user_id  fromT_alibaba_datawhereType= 0  andbrand_idinch(Selectbrand_id from(SelectBRAND_ID,Count(brand_id) asnew_brand_id fromT_alibaba_datawhereType= 1 Group  bybrand_idOrder  bynew_brand_iddescLimit0,Ten) alias_t1);

Sql/mysql Statement instances (updated ...)