I need to update the display_name column in all rows of my form table to replace any occurrences of 'NT NT' at the beginning of the display name with a single 'NT'. How do I do that given I need…
I have a table called, 'Songs'. This is the table structure. The table has an AlbumID column, which will be a foreign key reference to the Album table. The Songs table also has a 'status' column. Where it can be…
SELECT d.USPS_IMB AS IMb, d.CorrelationId, d.EINNo AS EIN, d.UniqueFormId AS FormId, d.ProductionFacility AS Facility, CASE WHEN d.ProductionStatusNo < 5 THEN 'Received' WHEN d.ProductionStatusNo = 5 THEN 'Printed' WHEN d.ProductionStatusNo = 6 THEN 'Folded / Sealed' WHEN d.ProductionStatusNo = 7 THEN…
So, I have a large set of numbers, basically 1001 .. 150000 for a database using MySQL There are a ton of gaps in the IDs on the database, so not all IDs exist. It can go from 100000 -…
I have a business that is open from 11am to 2am and I am trying to show a monthly sales totals. I already get the daily sales with no problem but I am trying to do a monthly sales with…
I have a table for recording the mark a student got in a subject on a particular date. The table, perf, has columns id,date,student,subject,mark. Objective: I want to compare the mark obtained by a student against the highest, the lowest…
Table 1: Name Address Height Weight X. y z. p G. H. I J Q W. E. R Table 2: Name Income Tax X. y z. Table 1 has more rows than table 2. All the Names in table 2…
I have these values(mentioned BELOW) which i'm trying to insert in (newly made) salary column of employees table. Salary column is INT NOT NULL DEFAULT 25000. 37000, 32000, 35000, 45000, 55000, 37000. I have got these values for emp_id column…
I have created one project in spring boot which is book-store . I have one post service which is used to take details of book and author also and save that into db [both book and author at same time].…
SELECT p.product_id, ROUND(COALESCE(SUM(price * units) / NULLIF(SUM(units), 0), 0), 2) AS average_price FROM Prices p JOIN UnitsSold u ON u.product_id = p.product_id AND u.purchase_date BETWEEN p.start_date AND p.end_date GROUP BY p.product_id; Only passes 15/17 test cases, not sure why Tried…