Write down a select statement that lists the studentid

Assignment Help Computer Engineering

Reference no: EM1333315

I have tried there two queries, but I am told that I am not doing something right. Here are the criteria I used to write the queries and my current answers.

1. Write a SELECT statement that lists the StudentID, FirstName, LastName, and GPA of freshman (FR) whose GPA is 3.5 or higher. Use only the Student table.
My query:
SELECT StudentID, FirstName, LastName, GPA
FROM Students
WHERE Year like '%FR%' AND GPA >= 3.5

2. Write a SELECT statement that returns all the information for junior and senior students whose GPAs are lower than 3.0. Sort by LastName in descending order. Use only the Students table.
My query:
SELECT *
FROM Students
WHERE GPA < 3.0 and Year like '%JR%' OR '%SR%'
ORDER BY LastName DESC

How can I edit my queries so that they are completely correct. The SQLyog is returning the correct answers, but I keep getting marked incorrect.

Reference no: EM1333315

Questions Cloud

Make a view called v_no_cost : Using the ITD410_P1 database you created for the Independent Project in Unit 1, write scripts in a file known ITD410_P3.SQL to create the following views. Remember to include a uses clause at the top of your script file to use the ITD410_P1 datab..

Arbitrage with forward and option contracts : What opportunity is open to an arbitrageur when a 180-day European call option to buy 1 Euro for $1.3083 costs $0.02 per Euro? Assume the size of forward and options contracts to be 1,000,000 Euros each. Ignore borrowing costs.

Explanation of the role of the hr manager : Explanation of the role of the HR manager - What do you think about below quote as a HR manager?

Explain significance of the tcp/ip protocol : Explain Significance of the TCP/IP protocol and What is the significance of the TCP/IP protocol in the ubiquitous e-commerce world we are entering

Write down a select statement that lists the studentid : I have tried there two queries, but I am told that I am not doing something right. Here are the criteria I used to write the queries and my current answers.

Intersecting indifference curves : Intersecting indifference curves would reflect a violation of the more is better principle.

Recovering from service failure : Recovering from a service failure requires different strategies and methods for hotel serving business travellers than for restaurant serving family dinners. State whether you agree or disagree.

Explain nsight into lack of security features : Explain Nsight into lack of security features or enhanced protocols and The architects of the new Internet Protocol address structure

Develop a human resource department : Develop a Human Resource Department for Titan Company -Can you help me to develop/write (the below 6 titles) a Human Resources department according to the data below

User Account

All Pages