Posts by Wagner • 11 points
6 posts
-
0
votes0
answers33
viewsQ: Postgress Query SQL
Hello. Provide the code and description of the group and the quantity of products associated with each of the groups. Order the result by the quantity of products of each group. I’m having trouble…
postgresqlasked Wagner 11 -
-1
votes1
answer41
viewsQ: Union Junction Operator
I need to present the departments that had stock movement in Feb/2018 and those that had in Mar/2018. I need to use a union operator to show the results of the two queries each of them returning the…
-
0
votes1
answer68
viewsQ: Average SQL Cost
Hello. I need to present the average cost, the lowest cost and the highest cost of all products and present the total of verified products. The table I have is this: Does anyone know how I love it?…
-
-1
votes1
answer34
viewsQ: Specific rows of a table
Hello! I have the table OPERATION where I have 3 columns: Codoper, Description, nauteness. I have to design the description and nature of all incoming operations. Then sort by the operation code.…
-
-1
votes2
answers52
viewsQ: SQL Join
I need to elaborate a query that brings the employee’s registration, employee’s name and employee’s city name using JOIN. But as I have no experience with this function yet, I am stuck!! For this I…
-
0
votes1
answer152
viewsQ: SQL rule to filter only one month in TIMESTAMP field
Hello. I have a stock drive in month 1, month 2, month 3, month 4, month 5... how do I create rule for appearing only stock drives in month 3? Remembering that the field is TIMESTAMP.