I have got 3 tables. Orders Clients Referrals ----- ----- ----- id id id total_price name name receiver_client_id status client_id While adding order, sometimes the receiver is CLIENT, sometimes REFERRAL, so receiver_client_id can have both client_id or referral_id. Referrals are…
I am trying some practice SQL problems and I am having trouble with one question. The question wants me to return a table that has [Test ID, Test Name, and Test Difficulty]. The issue is that I have to create…
I trying to fetch data from two related tables using a foreign key and keep the data as separate records / objects. The best solution I have found so far is using JOINs with column prefixing to differentiate between the…
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'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…
I have the two tables assets and transactions in my database, whereby transactions are connected to assets by the columns transactions.from_id and transactions.to_id: assets: id title 1 a1 2 a2 3 a3 transactions: id title from_id to_id 1 t1 1…
I have 2 tables that I join using LEFT JOIN, i.e. I take Name from table A and match it to Name from table B. There are some records that do not match and return null values due to it…
I will try my best to explain this. Let's say I have a table like this Name Year Present_category Present_count Mother Mary 2023 sweets 3 Linda Mary 2022 sweets 2 Linda Linda 2022 sweets 4 Linda 2021 sweets 1 Linda…
sample code SELECT b.title, i.barcode FROM biblio b JOIN items i ON b.biblionumber= i.biblionumber Join biblioitems bi ON i.biblionumber=bi.biblionumber where i.barcode IN (4088,6183,6191) above SQL given results as below, how do I get results in IN (4088,6183,6191) as entered order