Table information: | player_id | int | | device_id | int | | event_date | date | | games_played | int | +--------------+---------+ (player_id, event_date) is the primary key of this table. This table shows the activity of players of…
I have a table that looks like this id name count 1 Nishu 4 2 Shivam 2 3 Himanshu 1 I want to get the Output like this:- id name count 1 Nishu 4 1 Nishu 4 1 Nishu 4…
I've stored a X, Y coordinate system in mysql where x-axis values are from A, B....AA, AB... and so forth, just like columns are named in Excel. Y-axis values are from 1 to 100. I can't figure out how to…
How to get AVG of a column only if the all the row values for this specific column are not equal -1 ? I have a table with a column named quarter, Its value can be 0-100. But in case…
I am trying to find a way to calculate the running balance of an account. Below is my schema and the query I tried. CREATE TABLE transactions( id INTEGER NOT NULL PRIMARY KEY ,date DATE NOT NULL ,dr INTEGER NOT…
I have PostgreSQL SQL that should look for a backslash in a column called source_username and if it finds the backslash, it should replace the current value of the source_username column with the same value without the characters before the…
I have a table for blogs in a production site I am developing. The users can post these blogs and filter viewership to targeted audiences based on locations, roles, and groupings of users premade by them. All of these columns…
I have a table representing a card deck with 4 cards that each have a unique ID. Now i want to look for a specific card id in the table and find out which card in the deck it is.…
I have a table with created_at and deleted_at timestamps. I need to know, for each week, how many records existed at any point that week: week records 2022-01 4 2022-02 5 ... ... Essentially, records that were created before the…
I have a pretty big SQL query to get data from multiple database tables. I use the ON condition to check if the guild_ids are always the same and in some cases, he check's for an user_id too. That is…