Write 10 SQL statements against the STUDENT schema. Your statements should run error-free and should be valid. Submit two separate files: one plain text file (.txt or .sql file) with your statements only; and the other document (doc/docx/pdf) include both your statements and your query results (copy and paste text or screen shots). The instructor and TA should be able to run your plain text source file as scriipt and generate the same output as shown in your result document.
Q1. List all instructors. Show salutation in all lower cases, last name in all upper cases and phone number in the format of \'(xxx) xxx-xxxx\’. (HINT: use LOWER, UPPER and SUBSTR function)
Q2. List all students (display student_id, first name, last name, street address, zipcode, city, and state) who live in New York, NY. Sort results by last name, and then first name, in descending order.
Q3. Display the city in which each instructor lives. List first name, last name, zip, city, and state. Display \”N/A\” for zip, city, and state if an instructor does not have a zipcode. (HINT: left join INSTRUCTOR and ZIPCODE; use NVL function)
Q4. Show the number of instructors who live in NY state and has a street number of 518. (HINT: use string functions such as SUBSTR and INSTR)
Q5. Display the lowest, highest, and average numeric grade of Project grade type. (HINT: use the MIN, MAX, and AVG function; join GRADE and GRADE_TYPE)
— LEFT JOIN, DATE
Q6. List all students (display student_id, first name, last name, and registration date) who registered on or before 2/15/2007 but have not enrolled in any course. (HINT: left outer join STUDENT and ENROLLMENT; use the TO_DATE function)
— COUNT WITH 3-TABLE JOIN
Q7. Find how many students are enrolled in sections taught by Todd Smythe. (HINT: join INSTRUCTOR, SECTION, and ENROLLMENT)
— 4-TABLE JOIN
Q8. Show all students who are taking, or have taken the course \”Advanced Java Programming\”. List student name, enrollment date, and section location. (HINT: join COURSE, SECTION, ENROLLMENT, and STUDENT)
— 4-TABLE JOIN
Q9. List the students who have received any numeric grade score of at least 95 in an Advanced Java Programming course. Show student name, the grade type code, and the numeric grade.
— 4-TABLE JOIN WITH DISTINCT
Q10. List the instructors who teach Advanced Java Programming (having a section with students enrolled), without duplication. Show instructor name and course name. (HINT: use the DISTINCT keyword)
Learning Resources
https://www.w3schools.com/sql/sql_join.asp
https://docs.oracle.com/database/121/SQLRF/functions.htm#SQLRF006
List first name, last name, zip, city, and state.
Why us
Why Use Our AI Assignment Helper?
Saves Hours of Brainstorming
No more staring at a blank page. Our AI gives you a strong starting point — so you can focus on refining, not figuring out what to say.
Boosts Writing Clarity and Structure
Messy thoughts? Confusing prompts? Our tool delivers clear, logically structured content that flows — just like a polished draft should.
Ideal for Complex or Technical Prompts
Struggling with statistics, nursing case studies, or legal briefs? Our AI understands nuance and handles specific academic formats with ease.
Ideal for Complex or Technical Prompts
Struggling with statistics, nursing case studies, or legal briefs? Our AI understands nuance and handles specific academic formats with ease.
Helps You Meet Tight Deadlines
Whether it’s due in two hours or overnight, you’ll get instant, reliable help when you need it most — no panic necessary.
Supports Research-Based Work
Every answer includes reference links, source ideas, or research cues — so you're not just done, you're also better informed.
Do I need it?
Who It’s For
Our Ai modal has been specifically trained for academic purpose across all levels of education
College Students
University Undergraduates
Master’s Students
PhD Candidates
Working Professionals in Continuing Education
"Gain Academic Advantages From IntelliAssign`s Top Features"
Don't waste endless hours struggling with homework problems. Question AI assists students with all kinds of academic tasks with 98% accuracy rates. Get detailed answers to challenging homework and exam questions with our powerful AI homework technology.
How it all works
This is how to unlock comprehensive answers and master your studies with our homework AI, in a fast, accurate, and educational fashion.
1
Step 1
Enter your question, upload instructions, or paste your prompt
2
Step 2
Choose output type: Draft, Detailed Solution, or Step-by-Step Guide
3
Step 3
Our AI generates your content with research links and references
Features of Our AI Assignment Helper
No Signups. No Barriers.
Jump straight in — no accounts, no logins. Just paste your assignment and
get instant help. It’s that simple.
Instant Results, 24/7
Whether it’s midnight before a deadline or mid-morning study break, our AI
delivers fast, accurate solutions in seconds — anytime, anywhere.
References Included
Every answer comes with real research links, sources, or citations to guide
your learning or help support your submission.
Trained for Assignments
Unlike generic AI tools, our model is fine-tuned for real academic
assignments. Essays, case studies, care plans, reflections — it gets it.
Built for All Levels
From first-year college students to PhD candidates, our AI adjusts to your
academic level and writing expectations.
Multiple Output Styles
Need a draft? A detailed answer? A step-by-step guide? We’ve got modes
for how you like to work.
Real Stories, Real Results
5/5
4/5
5/5
4/5
4/5
FAQs
Do I need to sign up to use the tool?
Nope! You can use the tool instantly — no accounts, no logins, and no personal data required.
Is it really free?
Yes! You can generate assignment help for free. We believe academic support should be
accessible to everyone.
What types of assignments can it handle?
Our AI supports a wide range of academic tasks — including essays, research papers,
reflections, case studies, reports, presentations, and more — for college, university, master’s,
and even PhD levels.
How accurate are the answers?
The AI is trained specifically for academic assignments. It delivers high-quality, structured
responses and even includes references and research links where possible to back up its
solutions.
Can I get step-by-step explanations?
Absolutely! Choose the Step-by-Step Mode to get a breakdown of how to approach or solve
the question — great for learning and understanding the topic better.
Is it plagiarism-free?
Yes — the content is generated uniquely each time. However, we always recommend
reviewing, editing, and citing properly to match your academic standards.
Can I use it for any subject?
Yes! Whether its Nursing, Business, Computer Science, Literature, or Law — the tool is built to
adapt to different academic disciplines and writing styles.