Maximum discount product sql

Maximum discount product sql. FROM Products p1. To fix this, you can update all NULL values in the discount column to 0. `Product_Name` as `productName`. ORDER BY price_old - price DESC. PRODUCTID,COUNT(OD. Example 4: Use COALESCE () to Replace NULL with a Calculated Value. Orders. MySQL - select maximum May 14, 2014 · Consider we have three tables C1,C2 and C3. 4. orderID, o. Feb 2, 2017 · The SQL above produces a complete list of sales people per region like this. product_name, quantity from sales inner join salesman on salesman. Mar 6, 2017 · In the query below, I use a subquery to find the highest printer price in the Printer table. This tutorial shows you how to use the SQL MAX function to get the maximum value in a set. QUANTITY) AS Amount_Sold, SUM((P. 00 Asus Speaker 550. Aug 24, 2021 · SELECT *, (product_price - product_sell_price) / product_sell_price*100 as p_discount FROM `products` WHERE product_price IS NOT NULL AND p_discount > 25 ORDER BY p_discount DESC Share Improve this answer Aug 27, 2022 · Dummy ‘promo_codes’ table containing 3 offers (image by author) So before you roll out the promo codes, you may want to apply all the codes to all the products to see if any products may be Jun 20, 2020 · where LAT_N is the northern latitude and LONG_W is the western longitude. To find the average of unit prices for each product’s category, you can use the AVG function with the GROUP BY clause as the following query: SELECT categoryname, AVG (unitprice) FROM products INNER JOIN categories ON categories. 9 Select the name and price of all products with a price larger than or equal to $180, and sort first by price (in descending order), and then by name (in ascending order). Query: SELECT * FROM Products; Output: Step 5: Now, let’s make our query to compare the product sales by month. Example: What would I need to type in to work out: 2. I'm had trouble with an SQL problem on HackerRank (so nay grade or window functions): Product_Id Product_Name Choose Price Discount Available 1 P-1 C-5 Sep 11, 2023 · Amount can be calculated from Price and Discount of Product and Quantity sold. Oct 21, 2021 · The basic syntax is: SELECT COUNT([DISTINCT] <column_name>) FROM <table_name>. It is using a subquery in the WHERE clause to calculate the average "purch_amt" of orders for each customer by Dec 30, 2023 · Product Name Price Company Monitor 5000. Mar 2, 2015 · SET @p1 := (SELECT MAX(price) FROM items); SELECT * FROM items WHERE price = @p1; Using variables, p1 stores the maximum price from the table items and then uses the variable p1 in the following query to return all records which have that maximum price without limiting the number of records as you desired. select o1. categoryid GROUP BY categoryname; Code language: SQL (Structured Query Language) (sql) Apr 11, 2019 · WHERE b. Discount AS Final_Price, SUM(SD. You have Rs 1,000 * 0. This, along with color printing, are then used as requirements in the WHERE clause. insert into Discount (count_orders, percent_discount) values (0, 0); To find the percent discount for a customer with a given id, something like this: Easy SQL (Basic) Max Score: 10 Success Rate: 98. category = cc. Price-P. Result: To answer the comment below: "is there any way to display Category first then Products" this seemed to work: Get four FREE subscriptions included with Chegg Study or Chegg Study Pack, and keep your school days running smoothly. 1; from products where prod_name like 'HP%' It has one issue with the semicolon in the second row. SELECT AREA, COUNT(*) FROM SHOPPE GROUP BY AREA; 3. europe pieter tsu $546. 36%. MAXAMT; The inner-most query joins the ORDER, ORDER_LINE, and PRODUCT tables grouping by the customer ID to sum the total purchases for the current year (orders by summed amount descending). cusId IN (select cusId from orders group by cusId having count(*) = (select count(*) from orders or group by or. customer_id = a. Maybe I'm making some mistake there. - productID (Foreign Key) - discount (fractional value: percentage) - description. Given a set, we need to find maximum and minimum possible product among all subsets of the set. 00 Samsung DVD drive 900. Oct 9, 2021 · You can join the tables and aggregate to get the total sales for each product. ord_date. product is on maximum discount for each category. The SQL SUM() function can also be used along with other aggregate functions like MAX, AVG, & MIN. SELECT COUNT(CITY) — COUNT(DISTINCT CITY) FROM STATION ; X. select distinct [Sector], [Category], max(rec_cnt) from table. I have following table-structure (can be changed): PROMOTIONS (id, discount) PROMOTIONS_RULES (id, promotions_id, variable, operator, value) I've filled the table with following dummy-data: Max returns the maximum value of the column. subtotal, sum(o2. Now I have to find the Store type that sells the maximum products by the value of sales amount & by quantity sold. Write a query to print the following fields. : number of characters in the name). If you are using Oracle 12c, you can use the row limiting clause, something like. 20 SQL Practice Problems with Solutions. product_id = pc. - dealID. Sample table: item_mast. Output of the Query: The said SQL query that retrieves specific columns from the table item_mast and company_mast and the INNER JOIN clause to combine the data based Aug 23, 2019 · total_amt - It has Amount paid by customers for the particular products; Store_type - It has transaction channels; For example, if Qty ordered are 5 and price of each quantity of product is 100. Example 1: Use COALESCE () to Replace NULL with a Label. 71%. The discount is applied accurately, but the display is a bit confusing to the end user. FROM SaleDetail AS SD. qty as subtotal. Dec 3, 2019 · I have included a screenshot of the database. Exercise 6: Select Columns Using WHERE and LIKE. (. One way to deal with this problem (if you are working in a scripting language) is to use the group_concat function. cusId = c. Using ISNULL. 2). Joining the tables and then a group by on category_name and/or category_id. Create a table sales_details with 4 columns using the following SQL query. Join to the orderDetail table using ProductID. Nov 19, 2023 · If there are several products with the same maximum discount within a category, indicate the one with the lowest product_id. Solve Oct 31, 2013 · 0. Working out the percentage of a number. SELECT codigo_orden AS ORDER_ID, COUNT(codigo_producto) AS PRODUCTS_SOLD. salesman_name in ( select salesman. The store manager wants to find the average price of all distinct products that are purchased within a category for each category. Products. So I need to deduct 5% of the price as a discount. NAME VARCHAR2(256) NOT NULL, CATEGORIE VARCHAR2(64) NOT NULL PRICE NUMBER(9,2) NOT NULL Follow this example of database: The syntax of the MAX date function is as follows: sql. The maximum discount quantity feature does not quite work in the basket and product detail pages. cusId and o. The outer-most query joins the CUSTOMER_T Welcome to the Leetcode SQL series#leetcodesolution #leetcode #sql Link to the problem:https://leetcode. 4 5. sql; Maximum Sum in SQL. . *, o. " GitHub is where people build software. usa john doe $253. sale. salesman_name from sales inner join salesman on salesman. 1 where prod_name like 'HP%'; May 23, 2023 · USE AdventureWorks2022; GO SELECT AVG(ISNULL(Weight, 50)) FROM Production. To cover this case you need to group again and use your query in the HAVING clause : select productname. It is not needed, so remove it. rn=1. Aug 22, 2018 · For example: if the client has a baseball-cap AND a baseball mask in the cart AND the cart-sum is greater than 100 $ offer him 20$ discount. ORDER BY 2 DESC. select distinct salesman. CategoryName, Sum([Product Sales for 1997]. Try the following: SELECT count(p. SQL Max and Sum. You then subtract the discount from the original price as Rs 1,000 – Rs 200 = Rs Oct 11, 2013 · The database is SQL Server 2008 R2. price. It is ordered by the number of distinct order numbers in descending order and grouped by the "customer_id" column within the result set. 00 Frontech. product_id GROUP BY Nov 11, 2013 · In case the there are one or more customers having maximum orders: select * from orders o, customer c where o. This query returns the customer with the highest number of unique Apr 22, 2022 · 0. 79 (1 row(s) affected) B. ----- 59. Dec 20, 2011 · Deals. Query: Step 2: To use the GeeksforGeeks database use the below command. Giorgos Betsos. Could someone give me the SQL for this please, something like this - SELECT MAX(discount) AS Maxdisc , MIN(price) as MinPrice , FROM mytable GROUP BY discount Sep 12, 2022 · tables: CUSTOMER, PRODUCT, and PURCHASE. PRODUCTID) as Total. categoryid = products. e. It does this using the collating sequence so it can work on character and datetime columns in addition to numeric ones. Maximum product is obtained by multiplying. Alternatively I can do something like this: SELECT c. Drink_price= 2. My solutions to various hacker-rank SQL problems using DB2 syntax - chhayac/SQL-hackerrank-problems Jun 10, 2016 · For this to work properly, you need a discount for 0 orders as well. orderID, o1. The standard way of expressing this is: update products set price = price * 1. INNER JOIN Categories c on pc. europ mike lee $520. id int, name varchar(50), address text, grades varchar(50), phone varchar(10) Here, we created a table named Students with five columns. salesman_id = sales. Sql doesn't seem to like the '%' key. With this data you first select the maximum profit per day and then select those entries that match this: WITH PRODUCT_PER_DAY AS. from products. FROM A. category_name. GROUP BY codigo_orden. q2: Update the price with discount from the deals table. May 5, 2023 · 3. product_id = sales. Select id,discount. Exercise: For each purchased product, display its name, the largest quantity in which it has been purchased, and the number of max-quantity purchases for this product. Query: Step 3: Now we creating a table. INNER JOIN Products_to_Categories pc ON p. Weather Observation Station 5. Since you want an alternate without partition you can have a subquery to `have the max product sales amount for each region and use it to join in order to get the max sales product per region. salesman_name, product. select o. Optionally, you can specify the DISTINCT keyword to count only the unique occurrences of the values. In our example, the query returns the maximum number among all items. Exercise 1: Select All Columns. product_price), c. concept, price * (1 - discount / 100) total, currency. The production. The logarathm/power approach is the generally used approach. canada mike smith $114. WITH A AS (SELECT customer_id, MAX(Purch_amt) FROM orders) SELECT a. the combination of 'cust_country' and 'cust_city' should make a group, 2. CategoryName. We will follow a simple approach that is to traverse and multiply elements and if our value is greater than the previously stored value then store this value in place of the previously stored value. ProductID,Sum(OD. Write a query to print the following fields for eachcategory, ordered by productID ascending : category, product_id anddiscount for the product that has the max discount in category 1. Marks) AS Marks FROM c2 UNION SELECT (c3. Feb 16, 2016 · GROUP BY Category, Product WITH ROLLUP. salesman_id inner join product on product. I'm actually on SQL Server 2000 which may make this trickier Feb 21, 2017 · 9. The PARTITION BY clause divides the rows into groups based on the dept_id column. I've tried. model. Marks) AS Marks FROM c3 ) AS T GROUP BY (T. Suppose we want to find the average, maximum and minimum discount for each product, we can achieve it as such. ^ Chegg survey fielded between Sept. and your query should be. group by [Sector], [Category] having rec_cnt = max(rec_cnt) but no good. Write a SQL query to display the item name, price, and company name of all the products. parentcategory. SELECT SD. Try this! I am using a subquery to SELECT the maximum purchase amount per customer and then I added their respective date. products table stores the product’s information such as name, brand, category, model year, and list price. You can use the MAX () and MIN () function to get the ids having largest and the id having smallest discount. the group should be arranged in alphabetical order, Feb 5, 2024 · Time Complexity: O(N) Auxiliary Space: O(1) Maximum Product Subarray using Traversal From Starting and End of an Array:. Maker, p2. Write a query to print the following fields for each category, ordered by productID ascending : category, product_id and discount for the product that has the max discount in category. Sample Output C-1 2 17 C-2 3 19 C-4 4 5 C-5 1 10 Sep 17, 2016 · AND Y. This is because the discount of this product is NULL, and when you use this NULL value in the calculation, it results in a NULL value. ON p1. You would start with getting the sold amount per day and product. For this use the below command to create a database named GeeksforGeeks. But it didn't work. Quantity) as order_total from. From Orders O. Minimum product = -40. SQL Server provides MONTH and YEAR functions that allow us to find out the month and year respectively, from the given date. Step 1: We are creating a Database. GROUP BY Category, Product WITH ROLLUP. As you can see, its taken discount=60 group and separated the lowest price - 222, and the same for all other discount groups. for each category, ordered by category, ascending: category, product ID and discount for the. Jan 1, 2024 · Output of the Query: Explanation: The said SQL query is selecting all columns from the 'orders' table where the value in the "purch_amt" column is greater than the average "purch_amt" of orders associated with the same customer. UPDATE products SET discount = 0 WHERE discount IS NULL; Code language: SQL (Structured Query Language) (sql) Apr 2, 2014 · However that would return all sales, and not just the most sold product (with quantity). Dec 13, 2022 · Use case with other system functions like MIN, MAX, AVG. I have thousands of products so case will not help product Table: Category_ID Product_ID Price 1 12 120 1 19 234 2 10 129 3 34 145 3 11 100 4 8 56 I would like to find categories whose total price is neither maximum nor minimum using MySQL. select name, price from products where price >= 180 order by price desc , name asc ; Nov 19, 2023 · If there are several products with the same maximum discount within a category, indicate the one with the lowest product_id. For example, you may want to calculate the sale price of a shirt that regularly costs Rs 1,000. The following example selects the description, discount percentage, minimum quantity, and maximum quantity for all special offers in AdventureWorks2022. I think this is along the lines of what you're looking for. I even tried using Row_Number() and tried partitioning by customer name/year and ordering by revenue. UnitPrice * o2. Solution: Feb 21, 2017 · 9. com/problems/product-price-at-a-given-date/👉 Link to SQL QuestionA store maintains data on customers, products and purchaserecords in three tables: CUSTOMER, PRODUCT, PURCHASE. SELECT a. MARKS) DESC) AS R FROM ( SELECT (c1. EmployeeID,OD. id, c. Jun 19, 2019 · this code will help you. Jul 16, 2021 · The store manager wants to know which product is on its maximum discount for each category. QUANTITY) AS Sales_Amount. Query: Output: Look at the answer by @DanteTheSmith. FROM Products p. Avg returns the average or arithmetic mean of the values. model, p2. type, p2. 00 Epsion ZIP drive 250. Marks) AS Highest, ROW_NUMBER() OVER (ORDER BY MAX(T. The query up one level uses the inner query results and adds on the max summed total of purchases. The Relational diagram for this schema and tables which I'm working with looks like this: Relational Diagram. To associate your repository with the hackerrank-sql-solutions topic, visit your repo's landing page and select "manage topics. Otherwise, Inner Join will eliminate all the product (s) where there is no matching Order row available. If you are calculating amount for each EmployeeId you have to use one more table for join along with these tables. The columns are: Customer name, Year, Month, and Revenue. Oct 8, 2021 · In this article let us see SQL Query to Find the Highest Purchase Amount Ordered by Each Customer using MSSQL as a server. GMB. (b) Write the output of the following SQL. It returns the smallest value of the column and also works with several different data types. The table "Product" of a database contains the columns. id) AS num_products FROM categories AS c LEFT JOIN category_product AS cp ON c. --1. If the shirt is 20% off, you must convert 20% to a decimal (20/100 = 0. We have to use Independent Subquery. More than 100 million people use GitHub to discover, fork, and contribute to over 420 million projects. Examples: Input : arr[] = {4, -2, 5}; Output: Maximum product = 20. The examples with GROUP BY and HAVING clauses are also covered. Respondent base (n=611) among approximately 837K invites. Sample table: company_mast. FROM #product. salesman_id group Oct 12, 2010 · 1. The details of these system functions are given in the below pointers. then total_amt would be carrying 500. PRODID, P. Marks) ) SELECT Look at the answer by @DanteTheSmith. customer_id. I tried. Easy SQL (Intermediate) Max Score: 30 Success Rate: 94. category_id = c. where discount=(select MAX(discount) from customer) OR discount=(select MIN(discount) from customer); edited Nov 28, 2015 at 19:27. 2 = Rs 200. product_id where salesman. FROM cs_items. Exercise 3: Select Distinct Values From a Table. Employees. Exercise 4: Select Columns Using WHERE. You might consider to use the SaleDetail table on the left side of your query. model = p2. 1. Explanation: The said SQL query is selecting the product name, price, and company name from two tables 'item_mast' and 'company_mast' where the price of the product is the I'm having worry with at SQL problem on HackerRank (so no rank or view functions): Product_Id Product_Name Category Price Reduced Available 1 P-1 C-5 May 16, 2024 · SQL max () with group by and order by. q3: return all the products. cusId order by count(*) desc limit 1)); This solution is for MySQL, as I have used LIMIT. For example, SELECT group_concat(table. Oct 5, 2018 · Do Left join instead of Inner join. MAX – This function will return the highest or maximum value from the specified column or expression. JOIN Product AS P. [Product] ORDER BY LISTPRICE DESC) But It doesnt require subquery as such to do it if you still want you can use this. inner join [Order Details] as OD on OD. product that has the maximum discount in the category. For retrieving items: q1: Find all products in products with productID = all the productIDs in deals table. Dec 28, 2023 · SQL JOINS: Exercise-22 with Solution. REGIONID,OD. (Select T. category_id LEFT JOIN products AS p on p. Minimum product is obtained by multiplying. Mar 28, 2012 · If this needs to be a generic solution that handles both parent and child categories seemlessly, you can check for a match at either level (assuming all category names are unique, and every product has a category): select *. 24–Oct 12, 2023 among a random sample of U. region person thousands. INNER JOIN Printer p2. ProductSales) AS CategorySales. price * o. 61. The links highlighted above by Jrod are great references: SELECT AVG(p. answered Jun 1, 2020 at 19:46. QNTY = Y. Marks) AS Marks FROM c1 UNION SELECT (c2. product_id. Min is the inverse. left join categories cp on cp. SELECT MAX (column_name) FROM table_name; where: `column_name` is the name of the column that contains the date values you want to find the maximum of. Example 2: Use COALESCE () When Concatenating NULL and Strings. parent_id, count(p. RegionID,a. category_id. 00 iBall Printer 2600. Query: Step 5: The query for Inserting rows into the Table. FETCH FIRST 10 ROWS ONLY. 75 - 5%. Results: you can further manipulate the results: SELECT COALESCE(product,category,'Total') Category, SUM(Value) AS Value. SELECT DISTINCT NAME FROM ACCESSORIES WHERE PRICE> =5000; 2. brands ( brand_id INT IDENTITY (1, 1) PRIMARY KEY, brand_name VARCHAR (255) NOT NULL); Code language: SQL (Structured Query Language) (sql) Table production. ProductID) AS 'number of products that have not been sold'. To display Name, Price of all Accessories and their respective SName where they are available. Get four FREE subscriptions included with Chegg Study or Chegg Study Pack, and keep your school days running smoothly. customers who used Chegg Study or Chegg Study Pack in Q2 2023 and Q3 2023. Of course, since it’s an aggregate function, MAX() can also be used with groups. FROM products. I'd prefer to avoid an inner join in a nested query if possible but, saving the best for last. May 24, 2022 · Example SQL Queries Using COALESCE () Function. WHERE <conditions>; The COUNT() function appears in the SELECT part of the query and can accept a column name as an argument. Order Details. Here's how I tried to build the base query. OrderID=o Jun 10, 2013 · Second, you don't use the tm_markets table at all in the query. products. SELECT order_id, product_id, discount, AVG(discount) OVER (PARTITION BY product_id) AS avg_discount, MIN(discount) OVER (PARTITION BY product_id) AS min_discount, MAX(discount) OVER (PARTITION BY product_id) AS max_discount FROM order Jul 20, 2016 · Basically just started using sql and having a minor problem. It success. Sep 20, 2016 · For what I'm trying to solve, I'm using the following tables: - Product_Information - Categories_Tab - Order_Items. from customer. Oct 8, 2021 · Query: Step 2: To use the GeeksforGeeks database use the below command. Sep 4, 2014 · 0. id = cp. You can do something like: SELECT *. FREE Tinder™, DoorDash & more 2. Dec 11, 2017 · I'd ideally like to do this in one stepo. Create a max discount quantity discount that applies to a few products: in this specific case, I used a role requirement) with a 100% discount for a Example: SQL CREATE TABLE. `Product_Price`) as `minProductPrice`, MAX(`map`. Using the following code displays the correct minimum value: SELECT MIN(UnitsSold) FROM. `Product_Price`) as `maxProductPrice`, `pr`. FROM MYTABLE. canada pete dodd $45. Also use ROW_NUMBER() window function based on the category of the product and ordered by the total sales to rank each product and filter: But the num_products field is 4 for every row, which not-coincidentally is the total number of products. FROM [Product Sales for 1997] GROUP BY [Product Sales for 1997]. Solve Challenge. This is the data structure of question: Salesman Table SID SNAME LOCATION 1 Peter London 2 Michael Paris 3 John Mumbai 4 Harry Chicago 5 Kevin London 6 Alex Chicago Sep 21, 2022 · How to make a SQL Query to show the product categories that contains more than 1 product with price higher than 10. from products p. Nov 16, 2021 · Step 4: Viewing Inserted data. This will return a string with all prices for the same sale value, separated by a comma. PRODUCTID. For example, if we’d like to see the maximum number of items sold in each year, we can write this query: SELECT year, MAX(items) AS max_items FROM product GROUP BY year; You can calculate the discount as a percentage as follows. Here, int, varchar(50), and text specify types of data that could be stored in the Oct 19, 2014 · UPDATE products SET price = price*1. The outer-most query joins the CUSTOMER_T Dec 12, 2023 · Exercise 12: Display Purchased Products with Their Maximum Quantity Bought. To count all the product (s) having no order, use COUNT() function. Example 3: Use COALESCE () with Multiple Arguments. Discount)*SD. Jun 6, 2023 · We use SUM(salary) OVER(PARTITION BY dept_id) to get the total salary per department. Results: Sep 18, 2023 · Last Updated : 18 Sep, 2023. Nov 24, 2018 · select [ProductID] ,[Name] ,[Color] ,[ListPrice] from [Production]. answered Nov 28, 2015 at 14:38. The record having the biggest price_old - price difference will be returned first, followed by the record having the second biggest difference, etc. If you are not using 12c, then you can use a window function, for example. 220k 25 94 144. Jun 1, 2020 · That's simple arithmetics: select. The store manager wants to know which. CREATE TABLE production. Also, it is not standard SQL (although this will work in some databases). It can be 0. This can be used to determine the best value for money for a product by comparing the discount with the Mar 4, 2016 · 2. It appears that you want to see the orderid, the subtotal for each item in the order and the total amount for the order. I wanted to know whether there was a way to consolidate the highest discounts by category where category doesn't repeat Jan 31, 2023 · The formula to find the maximum discount product in SQL is: MAX(Discount) = MAX(Price)-MIN(Price); This formula calculates the maximum discount available on a product by subtracting the minimum price of the product from the maximum price. FROM [Product Sales for 1997] . S. Write a query to print category and the average of price minus discount for the Feb 29, 2024 · Table of Contents. UnitPrice*Quantity *(1-Discount)) as TotalAmount from Orders as o. HAVING Sum(ProductSales) > 100000; Category Sales for 1997, first quarter only, totals greater than $20000: SELECT DISTINCTROW [Product Sales for 1997]. usa jane smyth $120. 00 Zebronics Mother Board 3200. Exercise 2: Select Multiple Columns. The table data are as follow :-To find the 1st max value we use the following sql query: Query:;WITH CTE AS ( SELECT (T. Query: Step 4: Viewing the description of the table. The only problem with your query is the case where there are more than 1 products with average price equal to the maximum average price, because it returns only 1 row. JOIN orders o ON o. A department store maintains data on customers, products, and purchase records in three tables: CUSTOMER, PRODUCT, and PURCHASE. SELECT ORDER_DAY, PRODUCT_ID, SUM(QUANTITY * PRICE) AS SOLD_AMOUNT. I am, in fact, able to retrieve the value corresponding to the minimum units sold [95 in this case], but cannot also display the corresponding product name to that value in MS Access. FROM `bm_market_products` `map` join. 75 After 5%discount = 2. May 7, 2019 · 0. The resulting query should work: SELECT MIN(`map`. For Oracle, that is: select exp(sum(ln(col))) from table; I don't know why the original database designers didn't include PRODUCT() as an aggregation function. SELECT p1. Weather Observation Station 5 Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i. Rows with dept_id equal to 10 are put into one group (marked in yellow in the table above), the rows with dept_id equal to 20 are put into another group (marked in green), and finally the rows with dept_id equal to 30 are put in #Simplify_coding Dec 28, 2023 · The said query in SQL that retrieves the customer id, count of distinct order numbers, and maximum purchase amount from the 'orders' table. price) FROM table GROUP BY table. name, c. answered Mar 4, 2016 at 6:33. Mar 1, 2017 · 2. Repro: 1. Display three columns: product_name, quantity, and purchases_number. select O. The table we created will not contain any data as we have not inserted anything into the table. To get data of 'cust_city', 'cust_country' and maximum 'outstanding_amt' from the customer table with the following conditions -. My best guess is that they were all computer scientists, with no statisticians. Sep 23, 2013 · Product Price a 2 a 3 a 4 a 1 b 10 b 15 b 20 I want a query which will give be the max price at which product a was sold and max price at which product b was sold and nothing more. The storemanager wants to know which product is on its maximum discount foreach category. To display Minimum and Maximum Price of each Name of Accessories. canada joe blog $76. Product; GO Here is the result set. `table_name` is the name of the table that contains the column you specified in the `column_name` argument. Exercise 5: Select Columns Using WHERE with Text. [Product] where[ProductNumber] like 'BK%' and LISTPRICE IN (SELECT TOP 10 DISTINCT LISTPRICE FROM [Production]. bj yy zw qh tp xf zw ib ok fa