We have Employee ID in over 50 different tables with various data types (varchar, int, text). When these tables were populated via conversion, they should have been populated with 6 numbers. Unfortunately, some of the IDs had dropped leading zeros…
I have a table (audit) like so id | id_audit | id_booking -------------------------- 8 | 12345 | 10000 7 | 34567 | 10000 6 | 25608 | 10000 5 | 25864 | 10000 4 | 12345 | 10001 3 |…
Write a SELECT statement that answers this question: What is the total quantity purchased for each product within each category? Return these columns: The category_name column from the category table The product_name column from the products table The total quantity…
I have a subscription table with 4 fields: id, customer_id, start_date and end_date. It lists all subscriptions of my customers. No subscription has an empty end_date, and a customer can have several subscriptions at once. For example, a customer id…
I have two tables where the credit_limit of the customer table should determine the rating of each customer. In the end, the output should look like this, where the credit_limit determines the rating for each customer: cust_id credit_limit rating 400300…
I am developing a game like app with an leaderboard and want the leaderboard to have this features: Show Top 100 Show Top 100 Monthly, Weekly, Daily Show Trends next to every User (if the user moved up on the…
I have two tables A and B as below. Table A slip component amount ss-001 PF 1500 ss-001 PT 200 ss-002 PF 1450 ss-002 PT 150 ss-003 PF 1550 ss-003 PT 300 Table B emp slip netpay emp-001 ss-001 18500…
I have a problem here which i believe it has 2 solutions. Here is my first implementation with function overloading: type PostgresConnectionOptions = { dialect: "postgres"; config: pg.PoolConfig; }; type MysqlConnectionOptions = { dialect: "mysql"; config: mysql.PoolOptions; }; type SQLiteConnectionOptions…
I have a bit complex mysql select query question. I have 2 tables as shown in the image below. One is for products and the other one is the images of products. I can select the products with images with…
I Coded This Code: SELECT invoice.Date AS Inv_Date, COUNT(*) AS NoOfInv, SUM(Total) AS Inv_SumNetTotal FROM invoice WHERE invoice.Date BETWEEN DATE_FORMAT(NOW() - INTERVAL 1 MONTH, '%Y-%m-01') AND DATE_FORMAT(LAST_DAY(NOW() - INTERVAL 1 MONTH),'%Y-%m-%d') GROUP BY invoice.Date UNION ALL SELECT invoice.Date AS Inv_Date,COUNT(*)…