Q. write PostgreSQL for below question. must give the below 4 question answer.
Posted: Sat Feb 19, 2022 3:20 pm
Q. write PostgreSQL for below question. must give
the below 4 question answer.
points-6 1. Create table customers and insert data from file. points-6 2. Select customers for following predicate 'YTD SALES'<100000, 'YTD SALES'>=100000, and 'YTD SALES'>=300000 points-6 3. Show the customers who lives same city. points-12 4. create patition/fragment tabless for following predicates: 'YTD SALES'<100000, 'YTD SALES'>=100000, and 'YTD SALES'>=300000
the below 4 question answer.
points-6 1. Create table customers and insert data from file. points-6 2. Select customers for following predicate 'YTD SALES'<100000, 'YTD SALES'>=100000, and 'YTD SALES'>=300000 points-6 3. Show the customers who lives same city. points-12 4. create patition/fragment tabless for following predicates: 'YTD SALES'<100000, 'YTD SALES'>=100000, and 'YTD SALES'>=300000