Note that all files files uploaded without an account are acessible by a unique URL that is hidden but accesible by anyone, so we recommend you to sign up with an account if you want your files to be private, only your account will be able to access your files. We will be implementing this functionality in the web app soon. We allow time before auto deleting files just in case you're not done with the data, if you're done with viewing or converting a file and want to delete it right away, you can do it yourself through the API. Once you delete a file, it is deleted forever, we do not archive your data.We enforce a strict access policy and employees or external collaboratorsĪll data uploaded for conversion is automatically deleted forever
ROWNUMBER () overclause : Returns the number of the current row within its partition. Make sure that your payments table contains data that matches the filtering criteria you specified (i.e., amounts between 500,000 and 1,000,000). In addition, several existing aggregate functions now can be used as window functions for example, SUM () and AVG (). Finally, we format the total amount in thousands units and sort the result in descending order based on the total amount. Then, we group the data by the month and calculate the total amount for each month. In this query, we first filter the data using the WHERE clause to select only the rows with an amount between 500,000 and 1,000,000. SELECT DATE_FORMAT(paymentDate, '%b') AS Month,ĬONCAT(FORMAT(SUM(amount / 1000), 'K')) AS Formatted_amount You should filter the data first and then group it by the month. You're trying to group by the month, but you're missing the filtering condition for the amount.
It appears that your SQL query is quite close to what you want, but there's a small issue with the GROUP BY clause.