How do I calculate these two aliases and show them in other columns? SELECT SUM(qty1) AS ali_qty1, (SELECT SUM(qty2) FROM table2 WHERE col2 = 'B') AS ali_qty2, (SELECT SUM(ali_qty1) - SUM(ali_qty2) as total_qty) FROM table1 WHERE col1= 'A' table1 ID…
I have drawn a simple ERD: The query I perform: select s.*, count(c.store_id), count(p.store_id) from store s inner join customer c on c.store_id = s.id inner join product p on p.store_id = p.id group by s.id, s.store_name, s.address The result:…
I have this simple structure in my database CREATE TABLE species ( _id INTEGER PRIMARY KEY, name TEXT NOT NULL ); CREATE TABLE compatibility ( _id INTEGER PRIMARY KEY, speciesA INTEGER, speciesB INTEGER, compatibility TINYINT NOT NULL ); I want…
I am trying to query the code, name, and the number of rentals of customers who have made at least ten rentals. My query: Select client.ClientCode, client.ClientNom, (location.LocationRef) FROM client INNER JOIN location ON client.ClientCode = location.ClientCode WHERE location.LocationRef >…
I am trying to get the sum of particular field. I am getting the SUM wrong when I try to get the values together. I have this: reference: id_skill, user, level_paid More specifically the table reference as: id_skill user level_paid…
I have a table having below schema Item:Varchar Date:Date Quantity:Float trasactionid:int Sample Data: Item Date Quantity transactionid Part1 01-01-2023 10 3 Part1 01-01-2023 15 5 Part1 01-01-2023 17 2 Part1 01-01-2023 13 6 Part1 02-01-2023 13 7 Part1 02-01-2023 1…
I have a mysql table named 'access' with 2 fields: 'owner_id' and 'date_created_id'. I have another table named 'usersx' with 2 fields: 'id', and 'last_name'. I would like to use a single query to get both last names from the…
I have a table, Account, which I am querying to identify old accounts based on sales records. An account may have multiple rows in a Property table. A property may be closed. If all properties on an account are closed,…
create table A { id text, val text } create table B { val0 text, val1 text, val2 text } id and val of table A contain each a large, but discrete number of values in an many-to-many relationship. Sample…
I'm struggling with this for a while now and can't seem to figure it out. I have a clients, relations (which define relations and their type between clients) and consultations. What I wan't to do is count how many consultations…