I log the daily produced energy of my solar panels. Now I want to create a SQL statement to get the sum of produced energy for each month but separate columns for each year. I came up with the following…
I have a table called traffic shown below. I have to write a query which list all the protocols for which incoming traffic is higher than outgoing. The result should be in this format - protocol, traffic_in, traffic_out and sorted…
I need to create a single table with same column metrics aggregated for different time periods in Redshift SQL. Instead of repeating the code so many times with varying "WHERE" clause, is there a way I can reuse the code…
I am new to SQL and I've been struggling with this example for quite a while now. I have this table: So, what is asked from me is to produce a count of the number of recommendations each member has…
I have a table in Postgres with an hstore column like: "surface => concrete, ramp => yes, incline => up, highway => footway" "surface => asphalt, lit => no, source => survey, incline => 12.6%, highway => footway" "bicycle =>…
How do I calculate the negative difference between each row and return as a total sum? For example (col "fictional difference" is only for better understanding): id value fictional difference 0 63 0 -> ignrore 1 61 -2 2 55…
MySql issue: I want to extract the two best age_groups per region based on their wins. I haven't had much luck on this, having browsed similar issues. It's probably straightforward but mysql isn't playing nice for me this evening. region…
Let's say I have the following data table: id | data_1 | data_2 | category 1 | a | A | 1 2 | a | A | 1 3 | | B | 2 4 | b | B…
So I have 4 tables: post likes comments reads Each table has the column post_id I want to create a query, where for each post, i want to know the number of likes, the number of comments, and the number…
I recently gave test on codility platform and was stuck on below SQL question. Question: For an online platform assessments were conducted for 3 topics and scores were provided. Table: Assessments Input: |Id|experience|sql|algo|bug_fixing| |1 |5 |100|null|100 | |2 |1 |100|100…