I have some calculation and want to do this in the query. There is parent and children tables with one-to-many relationship: CREATE TABLE `parent` ( `id` int NOT NULL AUTO_INCREMENT, `value` decimal(10,2) DEFAULT NULL, PRIMARY KEY (`id`) ); CREATE TABLE…
I am using the Sakila Database for practice. I am calculating - Sales by Store. It provides a list of total sales, broken down by store. It incorporates data from the city, country, payment, rental, inventory, store, address, and staff…
I have two tables which I need to join: Table A, which has to be the leftmost table, and Table B, which must be joined onto it via LEFT JOIN. I cannot use a UNION in this scenario. Table A:…
I'm using mysql 8, I need to create a calculated field named status in the supplier table. When creating this field, it shows an error. where am i going wrong? Could it be a syntax error? create table tbqualificacao( idqualificacao…
In SQL I have following code: -- name: FilterRecords :many SELECT * FROM records WHERE industry_id = $3 and region_code = $4 and city_code = $5 OFFSET $1 LIMIT $2; What I'm trying to achieve is to exclude industry_id from…
I have a following table representing user activity in API endpoints. create table crud_logs ( id bigint generated always as identity constraint pk_crud_logs primary key, object_type varchar(255) not null, object_id bigint not null, action crudtypes not null, operation_ts timestamp with…
My foos each have a bar. At least they're supposed to. I now want to create and assign bars to all foos that don't. bar is completely detached from foo, it only has an id serial that serves as its…
I have array of object in which i need to sort based on condition using javascript. I need to sort the others list based on tariffId but in the order 7201, 7202, 7203, 7205, 7204 means always 7204 is the…
I'm successfully getting the sql data into an array, what I can't seem to work out is how to get that array to show in a chart.js chart. I can get the array into the dataset section but for some…
I am using json_build_object to build a json object using other columns: json_build_object(value1, qty1, value2, qty2, value3, qty3) Every pair (value, qty) go together. I only want the json object to contain the pairs that don't have an empty value.…