How should I practice Brands With Continuously Increasing Sales?

Start by reading the full statement, solve the visible examples, then compare the pattern against related Mastercard phone screen problems in FastPrep.

Is Brands With Continuously Increasing Sales associated with Mastercard?

FastPrep tags this as a Mastercard phone screen coding practice problem when the problem catalog has that company and stage context.

Brands With Continuously Increasing Sales

Mastercard● MediumFULLTIMEPHONE SCREEN

Problem statement

Each row in brand_sales contains one brand's total sales for one calendar month.

Return the brands that have at least three recorded months, whose recorded months are immediately consecutive, and whose sales amount increases strictly every month.

Return one row per qualifying brand.

Table schema

MySQLPostgreSQLPandas

Use the same input data with any supported language. Open the Schema tab in the editor to see the generated SQL setup or Pandas DataFrames.

brand_sales

Contains one monthly sales total per brand.

Column	Type	Nullable	Description
brand_idPK	Integer	No	—
sale_monthPK	Date	No	—
sales_amount	Decimal	No	—

Expected result

Your query or function must return these columns.

Column	Type	Nullable	Description
brand_id	Integer	No	—

Row order: must match exactly. Numeric tolerance: 0.

Constraints

(brand_id, sale_month) is unique.
sales_amount is nonnegative.
A brand must have at least three immediately consecutive calendar months.
Every sales amount must be strictly greater than the previous month's amount.
Sort by brand_id ascending.