I have a query to show the average length of all the proteins which also exists in a second table mrna_pieces: SELECT AVG(protein_length) FROM protein WHERE exists (SELECT protein_id FROM mrna_pieces WHERE mrna_brokstukken.protein_id = protein.protein_id) I also want to show…
I am using BIGSERIAL as a Primary key and I want to make use of the deleted row's ids. Example of the table that I want re-use the deleted ids from the deleted rows: DELETE FROM my_table WHERE id=3; INSERT…
I have a table that has some file input data with file_id and file_input_date. I want to filter / group these file_ids depending on file_input_date. The problem is my date is in format of YYYY-MM-DD HH:mm:ss and I want to…
Probably it's a simple question, many people asked similar questions before, but it's very hard to find an answer for my specific case. I have a complex query like that: SELECT val1, val2, val3 FROM table1 LEFT JOIN ... WHERE…
I have a table tab1 in timescale db which has 3 columns tag, time, value. time and tag make up the pk for the table: (time, tag). There are more than 500 lakhs (50 000 000) of rows. I need…
I have a table "users": drop table users; CREATE TABLE users( id int, user_id int, phone_number VARCHAR(30), email VARCHAR(30)); INSERT INTO users VALUES (1, 999, 61412308310, '[email protected] '), (2, 129, 61477708777, '[email protected] '), (3, 213, 61488908495, '[email protected]'), (4, 145, 61477708777,…
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…