Emilia | Material Design Music Player （neteasy api） | Music Player library

You can do this elegantly with the zip function (see also Javascript equivalent of Python's zip function). zip has an interesting property of being its own inverse, that is zip(zip([a, b])) === [a, b], so we zip both arrays into one, sort it and zip again.

Use isdigit

The statement if fnd_1.first_letter == fnd_2.first_letter and fnd_2.first_letter == fnd_3.first_letter is not correct, because you're comparing the functions themselves, rather than the output. For instance, fnd_1.first_letter is a function; if you want to actually run the function, and get its result, you have to use the following syntax: fnd_1.first_letter(). Adding the parentheses is necessary in order to actually call a function.

So, if you change your code to correctly call the functions, the relevant part would look like:

As you found out, you can't have two routes with the same path and HTTP method (GET /products) defined using different controller functions (listAllProducts, findCityProducts).

One simple approach you could take here is to adapt your controller function to behave differently depending on the existence of parameters in the URL.

Also, it is worth noting that you should be sanitizing any external input before using them in SQL queries to avoid injections.

You can use a query to order the items by their timestamp value

Create a measure that counts distinct customers in f_orders. If you use that measure in a visual that groups/filters by date, then that measure will show the correct values.

For example a chart with date on the X axis and the distinct customer count as the value will then show the distinct count for each day.

In Power BI/DAX, you don't need to pre-calculate all kinds of scenarios because the measure will always get evaluated in the context of the filters of the page/visual.

Use sum, str.count, and a generator expression:

Try this code

You can just use grep with an email regex: