245 Answered Questions for the topic SQL

03/17/21

SQL QUESTION W3schools
This is the database that i want to use, https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_inFind the average price for all the products from the USA supplier.
Follows • 1
Expert Answers •1

03/17/21

Database SQL Question
using https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in, we want to find the number of products in the table Products (the table has 77 rows) that was sold to the USA customers. No... more
Follows • 1
Expert Answers •1

02/26/21

POS Design the system based- but is not limited to the technical and user requirements
A Point-of-Sale (POS) system is where your customer makes a payment for products or services at your store. The POS serves as the central component for your business; it’s the hub where... more
Follows • 1
Expert Answers •1

01/15/21

Database management System
Write a menu driven program to create and operate on a relational database that, prospectively, can be used by a library using Java or C++ One relation is stored in one data file.... more
Follows • 0
Expert Answers •1

12/21/20

Database Questions

1.     Discuss some applications of active databases.2.     Discuss how time is represented in temporal databases and compare the different time dimensions. 3.     What are the differences between... more
Follows • 1
Expert Answers •1
Sql

12/04/20

What am I not doing to return 16 states in an alias field?
--Write a query that returns a field called below_average_states_y2000 --that lists all states--with an avg_math_4_score less than the average over all states --in the year 2000I've rewritten this... more
Follows • 1
Expert Answers •1
Sql

11/11/20

Deptmaster (deptid,deptname, dlocation), coursemaster (deptid, courseid,coursename), strengthmaster (deptid, courseid, maxstudentallow), studentdetails (deptid, courseid, studno, studname);
1) display the department and course where maximum students registered2) select name, department and course of student whose names begin with 'A'3) display department name of student having student... more
Follows • 2
Expert Answers •2
Sql

11/09/20

Deptmaster (deptid,deptname, dlocation), coursemaster (deptid, courseid, coursename), strengthmaster (deptid, courseid, maxstudentallow), studentdetails (deptid,courseid, studno, studname);
1) display the department and course where maximum students registered2) select name, department and course of student whose name begin with 'A'3) display department name of student having student... more
Follows • 1
Expert Answers •1
Sql

11/04/20

1.Find the names of all juniors (level=juniors)who are enrolled in a class taught by prof.Ram

Student (anum,shame,mainsubject,level,age)Class(name,meetsat,room,fid)Enrolled (anum,cname)Faculty (fid,cname,deptid)2.finad the age of the oldest students who either a history main or is enrolled... more
Follows • 2
Expert Answers •1
Sql

11/04/20

Find the SQL query?? Find the name of students whose are not enrolled in any class
Follows • 2
Expert Answers •1

09/24/20

database assignment

You are working in a Library and the Supervisor has asked you to create a database to store the data in the tables below. use MS access any versionUsers... more
Follows • 1
Expert Answers •1

07/13/20

Looking for a tutor! I am self-taught in Node, Express, Python and SQL
Hey there!My name is James, and I started teaching myself html and css about 5 years ago, then jumped into javascript.I am hoping to change direction and focus on python and sql, more along the... more
Follows • 1
Expert Answers •1

04/09/20

ER Diagrams - relations
The SingLanka Record Bar has decided to store information about musicians who perform on its albums in a database. Consider the following requirements to design a database for the company... more
Follows • 1
Expert Answers •1
Sql Analytics

02/14/20

Data analyst sample question
The table has 4 fields: date, event_name, video_id and user_id. Write a query that will return the number of users who viewed at least one video in a given day and the number of those users who... more
Follows • 1
Expert Answers •1

02/10/20

Help combining two Oracle SQL queries
I am using 2 SQL queries. the 2nd produces additional columns not contained in the first query.I would like to see if they can be combined so the original query produce same original data plus the... more
Follows • 1
Expert Answers •1
Sql Html

01/03/20

I have developed this but email goes blank but actualy there is data in the table?? below i have excluded try catch block
ALTER PROCEDURE [dbo].[spReportDataSync_log]ASBEGIN declare @last date = DATEADD(DAY, (DATEDIFF(DAY, 4, GETDATE()) / 7) * 7-7 , 4) declare @current date = DATEADD(DAY ,7, @last) DECLARE... more
Follows • 2
Expert Answers •1
Sql

10/23/19

Database Foundations
How are unary relationships associated with entity types?Customer data, Intersection, different entity types, or are the same entity types?
Follows • 1
Expert Answers •1
Sql

10/10/19

SQL query to a relational algebra
How I can translate the SQL query to a relational algebra expression?SELECT P.Name FROM Players P, Games GWHERE P.Id =  G.PlayerId    AND P.Game = 'Football' AND G.Season ='2019'where:... more
Follows • 1
Expert Answers •1
Sql T Sql

09/11/19

SQL/Yardi Mentor
Does anyone have experience with SQL and Yardi?
Follows • 1
Expert Answers •1
Sql

09/01/19

show department name and no of employees against each department and manager name of each (also show departments with no employees).
i am using hr schema employees and departments tables.
Follows • 1
Expert Answers •1

07/12/19

How to execute raw SQL in SQLAlchemy-flask app?
How do you execute raw SQL in SQLAlchemy? I have a python web app that runs on flask and interfaces to the database through SQLAlchemy. I need a way to run the raw SQL. The query involves... more
Follows • 1
Expert Answers •1

07/12/19

How to perform OR condition in django queryset?
I want to write a Django query equivalent to this SQL query: SELECT * from user where income >= 5000 or income is NULL. How to construct the Django queryset filter? ... more
Follows • 1
Expert Answers •1

06/30/19

Structured data
Hi i am doing research about Structured data and I am not able to find significant information about Structured data.What are the different types of Structured data?What are the advantages and... more
Follows • 1
Expert Answers •1

06/28/19

List all movie titles and years in which Tommy Chong appeared (hint; sometimes the name column in the actor table contains multiple names, so you want to find any that contain this name)
List all movie titles and years in which Tommy Chong appeared (hint; sometimes the name column in the actor table contains multiple names, so you want to find any that contain this name)
Follows • 1
Expert Answers •1

06/19/19

General rules for simplifying SQL statements?
I'm looking for some "inference rules" (similar to set operation rules or logic rules) which I can use to reduce a SQL query in complexity or size. Does there exist something like that? Any... more
Follows • 1
Expert Answers •1

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.