Posts by M.Amaral • 177 points
4 posts
-
1
votes1
answer422
viewsQ: How do Extent Reports generate an HTML report when the test fails outside the @Test tag?
I created a report template for my test project that is up to now meeting my demand, however, if the test fails outside the@Test tag the report is not generated (being some connection error, or…
-
3
votes1
answer6636
viewsQ: How to calculate the average using conditions in SQL Server?
The question asks me to show the number of students with averages greater than 7, less than 7 or equal to 7 for some tables I have here. Thus showing: How to create this column of Description?…
-
10
votes3
answers8992
viewsQ: Select first record within a segmentation in SQL Server
I have the following example table: The consultation asks me to show which students entered first in each course. I can tell which student entered the university first, using the function top(1),…
-
2
votes1
answer637
viewsQ: How to compare the values of a column with the average of these values in SQL?
I have a column of books, and I just want to show the books that the price is higher than the average of those prices, how to do that? The name of my column is price, and I can’t put a where price…