I've been required while online self learning to do as title shows. this is the info of the quesion: Accounting Instruction Write a query to select the amount of sales by country. Order the result by descending amount. Produce exactly…
Below is the postgres table table1: CREATE TABLE table1 ( id INT PRIMARY KEY, name TEXT, skills JSON ); with below rows inserted: INSERT INTO table1 (id, name, skills) VALUES (1, 'Alice', ‘[ {“sid" : 11, "description" : “Cardio"}, {"sid"…
I have a Mysql InnoDB table with storage size(+index) over 2,000GB, There are 14 billion rows in that table.. I need to drop data added over 1 month ago, and figure out a way to always keep recent 1 month…
I encountered a problem when working with regular expressions in PostgreSQL. It turns out that PostgreSQL has no support for the p{Lo} class, which corresponds to the "Letter, Other" category in the Unicode standard. I need to use this class…
I have a requirement to dynamically execute a query string. For this I have written a function which generates this query string. The function successfully returns the right query string depending upon the client name that I pass, however, I…
Data Definition I have a status table like so, attributes not relevant to the question are omitted: id created value 1 2024-06-24T13:01:00 error 2 2024-06-24T13:02:00 ok 3 2024-06-24T13:03:00 warning 4 2024-06-24T13:04:00 error 5 2024-06-24T13:05:00 error 6 2024-06-24T13:05:30 error 7 2024-06-24T13:06:00…
I came across this question on a coding platform One single table is given. It is of the following format: Temperature_records Record_date Data_type Data_value 2020-07-01 max 92 2020-07-01 min 71 2020-07-01 avg 74 2020-07-02 max 90 2020-07-02 min 67 2020-07-02…
Given the following sql table | id | name | mother | father | brothers | |----|-------|--------|--------|-----------| | 1 | danny | 3 | 2 | {4, 6, 7} | | 2 | bob | 20 | 30 | {}…
I was working on parsing sql queries and then turning them into their parse trees, but in calcite, the smallest node is broken down to SqlIdentifier. Which doesn't specify the context of the node. I want to know if that…
I have a table app_order with columns price (a number) and side (side can be either 'up' or 'down'). I need to write a postgreSQL condition within a WHERE clause that filters app_order entries for which price is both: bigger…