Question: Consider the dataset in Table 3, where all the values in columns 2 to 6 are between 0 and 100. Studentin CA1 grade CA2 grade

Consider the dataset in Table 3, where all the values in

Consider the dataset in Table 3, where all the values in columns 2 to 6 are between 0 and 100. Studentin CA1 grade CA2 grade Lab grade Final grade GPA Si Labi Finali GPA, : : : : : : CAli CA21 Table 3: Student grades For each of the following, write a Pig script that 1. Calculates the average GPA of the students whose average CA grade is lower than their lab grade. 2. Calculates the average final grade without considering the students who had the highest and the lowest lab grades. For example, if students with IDs id18 and id27 had the lowest lab grade because they didn't submit their work, their final grade should not be considered in this calculation. 3. Sorts the students based on the difference of their final grade to their GPA

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Name: T.A. name/Class time: MW Lecturer: Lab 11: Multiple Regression Open the lab dataset on Blackboard Learn or previously saved in SPSS. This dataset contains the data for 96 subjects. The...

unit II q12. Summarized on the right is the sale (in thousands) of the top five products in 2002. Use this information to calculate what percent of the sales of these five products was due to product...

12:38 4 Assignment Details MTH 154-N41A: Quantitative Reasoning (SP21) MTH 154 Excel Project In this major project, you will create an Excel file and answer questions about linear and exponential...

The objective of the Homework assignment is to provide an opportunity to apply or practice the tools and techniques covered in the course and to provide an opportunity to articulate key concepts...

ADMN 233 Assignment 4 Assignment 4 Instructions Assignment 4 is worth 20% of your final mark. It should be completed and submitted after you finish Chapter 13 in your textbook. This assignment is...

please do it in java, no use of any sort of java library @Test public void test03b() { Participant heeyeon = new Participant("H. Y. Kang"); Registration r1 = new Registration("EECS2001");...

what about now plz say that is clear Oh Ganh M Share Comments I CRAPAT GT MIG SECOND File Home Insert Page Layout Form Date Www H & Auto Be France Totalb M M Tine Me Tigcom O Studente Mortgage...

please do it in java, no use of any sort of java libraries package junit_tests; import static org.junit.Assert.*; import org.junit.Test; /* * Requirement: Any classes you create must reside in the...

Set Week Three During this week, we will look at ways of testing multiple (more than two) data samples at the same time. We will continue to use the data and assignment file that we opened in Week 2,...

Step 1: The Data Analysis Plan In Step 1: Name the four variables used in this analysis and whether they are categorical or continuous. State a research question, null hypothesis, and alternate...

For the set lunch at Amelias Restaurant, customers can select one meat dish, one vegetable, one beverage, and one dessert. The menu offers two meats (beef and chicken), three vegetables (corn, green...

A fishing boat is purchased for $5,600 and financed for 36 months. If the total finance charge is $ 1,025, find the annual percentage rate using Table 12-1.

c . Corbin, age 1 5 and single, is a dependent of his parents. Corbin has wages of $ 2 , 3 0 0 and interest of $ 4 7 5 . A . Corbin need not file because his gross income of $ 2 , 7 7 5 is less than...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Imagine that the U.S. Congress, recognizing the importance of being well dressed, started giving preferential tax treatment to clothing insurance. Under this new type of insurance, you would pay the...

Find some information on an index fund (such as the Vanguard Total Stock Market Index, ticker symbol VTSMX). How has this fund performed compared with other stock mutual funds over the past 5 or 10...

According to an old myth, Native Americans sold the island of Manhattan about 400 years ago for $24. If they had invested this amount at an interest rate of 7 percent per year, how much would they...