I have the following table ticks datetime lowest_tick tick_lower 2022-10-01 00:02:00 204406 204306 2022-10-01 00:03:00 204525 204425 2022-10-01 00:04:00 204414 204314 2022-10-01 00:05:00 204200 204100 2022-10-01 00:06:00 204220 204120 2022-10-01 00:07:00 204120 204020 What I want to get is to…
I found an issue in my query: SELECT * FROM stocks_historic WHERE ticker = x ORDER BY YEAR ASC LIMIT 10 Current table is this one: stocks_historic ( historic_id SMALLSERIAL UNIQUE, ticker VARCHAR(10) NOT NULL, year VARCHAR(5) NOT NULL, eps…
I think it's impossible, but I'm asking if there's a good way. There are A table / B table / C table. The table was joined LEFT JOIN based on table A with FK called id of each table. At…
I am trying to build query that gets data from 3 different tables using sqlalchemy I tried select( models.Animals.id, models.Animals.description, models.AnimalTypes.name.label('type'), func.coalesce( func.array_agg( func.jsonb_build_object( 'id', models.Animals.id ) ), None ).label('animals') ) .join(models.FamilyTypes, models.Family.id == models.Family.family_type_id) .outerjoin(models.Animals, models.Animals.campaign_id == models.Animals.id) .group_by(models.Family.id,…
MySQL fulltext search doesn't match the word 'christoffer82' and its ilk with the root word 'christo' and I have no idea why. This login only appears once in the table (it doesn't appear in more than 50% of the results)…
I am having 3 tables - student, department and exam_results. What I am trying to do here is to select all of the department/s name/s which have the highest grade for example 6. I have tried the following query but…
I am trying to count matching values from customer column on table 'Customers' and update their values on the Count Column in table 'Summary'. I also want to Check if the Date is <= Todays Date. Table "Customers": ID Customer…
I have a MySQL database with lots of entrys with columns like "local_time", "temp", "wind", etc. What I want to archive is get in just one query the MIN value for temp, the MAX value for temp in each day…
There's a simple table with columns a,b,c,d. I want value in d to be a+b if c>0 and a-b if c<=0. How can I do this? I tried this code and it doesn't work. How can I dynamically insert data…
I'm thinking my way to do that is a little archaic, not optimized... i don't need super detailed statistics, lets say i want the number of clicks on a link on a blog post per (actual) day/week/month/year nothing more, don't…