Need help on 2 SQL based questions [on hold]











up vote
-4
down vote

favorite














  1. Given the following table definition, select all city names in descending order:



    TABLE cities
    
id INTEGER NOT NULL PRIMARY KEY
    
name VARCHAR(30) NOT NULL



  2. Given the following table definitions, write a select statement to get the following values ClaimantName, PolicyNumber, UMR, InsuredType, Insurer using joins:



    TABLE Claims
    
ID INTEGER NOT NULL PRIMARY KEY
    
ClaimantName VARCHAR(30) NOT NULL
    
InsurerID INTEGER NOT NULL FOREIGN KEY
    
BrokerID INTEGER NOT NULL FOREIGN KEY
    
PolicyID INTEGER NOT NULL FOREIGN KEY
    

    
TABLE Policies
    
ID INTEGER NOT NULL PRIMARY KEY
    
PolicyNumber VARCHAR(30) NOT NULL
    
BinderID INTEGER NOT NULL FOREIGN KEY
    
UMR VARCHAR(30) NOT NULL
    
Insured Type VARCHAR(30) NOT NULL
    

    
TABLE Insurers
    
ID INTEGER NOT NULL PRIMARY KEY
    
CompanyName VARCHAR(30) NOT NULL
    

    
TABLE Binders
    
ID INTEGER NOT NULL PRIMARY KEY
    
BinderName VARCHAR(30) NOT NULL
    
CarrierID INTEGER NOT NULL FOREIGN KEY
    

    
TABLE Carrier
    
ID INTEGER NOT NULL PRIMARY KEY
    
CarrierName VARCHAR(30) NOT NULL







sql







share|improve this question









New contributor




user3590637 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as too broad by jarlh, Gordon Linoff, a_horse_with_no_name, Andrew, gnat Nov 19 at 13:58


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.











  • 4




    Homework? What have you tried? Remember that if we do it for you, you won't learn much.
    – jarlh
    Nov 19 at 12:27










  • it was a quiz for a potential employer that was about JS but these 2 questions were tagged on at the end so i need abit of help understanding how to do them before i start to properly learn SQL
    – user3590637
    Nov 19 at 12:30












  • Hint for the first question: order by, hint for the second question join
    – a_horse_with_no_name
    Nov 19 at 12:32










  • thanks for the hints, im assuming ORDER BY NAME DESC; would work from what i can see
    – user3590637
    Nov 19 at 12:35








  • 2




    Why not simply create the tables and insert some data. Then it's easy to verify your queries.
    – jarlh
    Nov 19 at 12:51















up vote
-4
down vote

favorite














  1. Given the following table definition, select all city names in descending order:



    TABLE cities
    
id INTEGER NOT NULL PRIMARY KEY
    
name VARCHAR(30) NOT NULL



  2. Given the following table definitions, write a select statement to get the following values ClaimantName, PolicyNumber, UMR, InsuredType, Insurer using joins:



    TABLE Claims
    
ID INTEGER NOT NULL PRIMARY KEY
    
ClaimantName VARCHAR(30) NOT NULL
    
InsurerID INTEGER NOT NULL FOREIGN KEY
    
BrokerID INTEGER NOT NULL FOREIGN KEY
    
PolicyID INTEGER NOT NULL FOREIGN KEY
    

    
TABLE Policies
    
ID INTEGER NOT NULL PRIMARY KEY
    
PolicyNumber VARCHAR(30) NOT NULL
    
BinderID INTEGER NOT NULL FOREIGN KEY
    
UMR VARCHAR(30) NOT NULL
    
Insured Type VARCHAR(30) NOT NULL
    

    
TABLE Insurers
    
ID INTEGER NOT NULL PRIMARY KEY
    
CompanyName VARCHAR(30) NOT NULL
    

    
TABLE Binders
    
ID INTEGER NOT NULL PRIMARY KEY
    
BinderName VARCHAR(30) NOT NULL
    
CarrierID INTEGER NOT NULL FOREIGN KEY
    

    
TABLE Carrier
    
ID INTEGER NOT NULL PRIMARY KEY
    
CarrierName VARCHAR(30) NOT NULL







sql







share|improve this question









New contributor




user3590637 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as too broad by jarlh, Gordon Linoff, a_horse_with_no_name, Andrew, gnat Nov 19 at 13:58


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.











  • 4




    Homework? What have you tried? Remember that if we do it for you, you won't learn much.
    – jarlh
    Nov 19 at 12:27










  • it was a quiz for a potential employer that was about JS but these 2 questions were tagged on at the end so i need abit of help understanding how to do them before i start to properly learn SQL
    – user3590637
    Nov 19 at 12:30












  • Hint for the first question: order by, hint for the second question join
    – a_horse_with_no_name
    Nov 19 at 12:32










  • thanks for the hints, im assuming ORDER BY NAME DESC; would work from what i can see
    – user3590637
    Nov 19 at 12:35








  • 2




    Why not simply create the tables and insert some data. Then it's easy to verify your queries.
    – jarlh
    Nov 19 at 12:51













up vote
-4
down vote

favorite









up vote
-4
down vote

favorite













  1. Given the following table definition, select all city names in descending order:



    TABLE cities
    
id INTEGER NOT NULL PRIMARY KEY
    
name VARCHAR(30) NOT NULL



  2. Given the following table definitions, write a select statement to get the following values ClaimantName, PolicyNumber, UMR, InsuredType, Insurer using joins:



    TABLE Claims
    
ID INTEGER NOT NULL PRIMARY KEY
    
ClaimantName VARCHAR(30) NOT NULL
    
InsurerID INTEGER NOT NULL FOREIGN KEY
    
BrokerID INTEGER NOT NULL FOREIGN KEY
    
PolicyID INTEGER NOT NULL FOREIGN KEY
    

    
TABLE Policies
    
ID INTEGER NOT NULL PRIMARY KEY
    
PolicyNumber VARCHAR(30) NOT NULL
    
BinderID INTEGER NOT NULL FOREIGN KEY
    
UMR VARCHAR(30) NOT NULL
    
Insured Type VARCHAR(30) NOT NULL
    

    
TABLE Insurers
    
ID INTEGER NOT NULL PRIMARY KEY
    
CompanyName VARCHAR(30) NOT NULL
    

    
TABLE Binders
    
ID INTEGER NOT NULL PRIMARY KEY
    
BinderName VARCHAR(30) NOT NULL
    
CarrierID INTEGER NOT NULL FOREIGN KEY
    

    
TABLE Carrier
    
ID INTEGER NOT NULL PRIMARY KEY
    
CarrierName VARCHAR(30) NOT NULL







sql







share|improve this question









New contributor




user3590637 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.













  1. Given the following table definition, select all city names in descending order:



    TABLE cities
    
id INTEGER NOT NULL PRIMARY KEY
    
name VARCHAR(30) NOT NULL



  2. Given the following table definitions, write a select statement to get the following values ClaimantName, PolicyNumber, UMR, InsuredType, Insurer using joins:



    TABLE Claims
    
ID INTEGER NOT NULL PRIMARY KEY
    
ClaimantName VARCHAR(30) NOT NULL
    
InsurerID INTEGER NOT NULL FOREIGN KEY
    
BrokerID INTEGER NOT NULL FOREIGN KEY
    
PolicyID INTEGER NOT NULL FOREIGN KEY
    

    
TABLE Policies
    
ID INTEGER NOT NULL PRIMARY KEY
    
PolicyNumber VARCHAR(30) NOT NULL
    
BinderID INTEGER NOT NULL FOREIGN KEY
    
UMR VARCHAR(30) NOT NULL
    
Insured Type VARCHAR(30) NOT NULL
    

    
TABLE Insurers
    
ID INTEGER NOT NULL PRIMARY KEY
    
CompanyName VARCHAR(30) NOT NULL
    

    
TABLE Binders
    
ID INTEGER NOT NULL PRIMARY KEY
    
BinderName VARCHAR(30) NOT NULL
    
CarrierID INTEGER NOT NULL FOREIGN KEY
    

    
TABLE Carrier
    
ID INTEGER NOT NULL PRIMARY KEY
    
CarrierName VARCHAR(30) NOT NULL







sql




sql






share|improve this question









New contributor




user3590637 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




user3590637 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited Nov 19 at 12:28









Lee Mac

2,90021036




2,90021036






New contributor




user3590637 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked Nov 19 at 12:26









user3590637

1




1




New contributor




user3590637 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





user3590637 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






user3590637 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




put on hold as too broad by jarlh, Gordon Linoff, a_horse_with_no_name, Andrew, gnat Nov 19 at 13:58


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.






put on hold as too broad by jarlh, Gordon Linoff, a_horse_with_no_name, Andrew, gnat Nov 19 at 13:58


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.










  • 4




    Homework? What have you tried? Remember that if we do it for you, you won't learn much.
    – jarlh
    Nov 19 at 12:27










  • it was a quiz for a potential employer that was about JS but these 2 questions were tagged on at the end so i need abit of help understanding how to do them before i start to properly learn SQL
    – user3590637
    Nov 19 at 12:30












  • Hint for the first question: order by, hint for the second question join
    – a_horse_with_no_name
    Nov 19 at 12:32










  • thanks for the hints, im assuming ORDER BY NAME DESC; would work from what i can see
    – user3590637
    Nov 19 at 12:35








  • 2




    Why not simply create the tables and insert some data. Then it's easy to verify your queries.
    – jarlh
    Nov 19 at 12:51














  • 4




    Homework? What have you tried? Remember that if we do it for you, you won't learn much.
    – jarlh
    Nov 19 at 12:27










  • it was a quiz for a potential employer that was about JS but these 2 questions were tagged on at the end so i need abit of help understanding how to do them before i start to properly learn SQL
    – user3590637
    Nov 19 at 12:30












  • Hint for the first question: order by, hint for the second question join
    – a_horse_with_no_name
    Nov 19 at 12:32










  • thanks for the hints, im assuming ORDER BY NAME DESC; would work from what i can see
    – user3590637
    Nov 19 at 12:35








  • 2




    Why not simply create the tables and insert some data. Then it's easy to verify your queries.
    – jarlh
    Nov 19 at 12:51








4




4




Homework? What have you tried? Remember that if we do it for you, you won't learn much.
– jarlh
Nov 19 at 12:27




Homework? What have you tried? Remember that if we do it for you, you won't learn much.
– jarlh
Nov 19 at 12:27












it was a quiz for a potential employer that was about JS but these 2 questions were tagged on at the end so i need abit of help understanding how to do them before i start to properly learn SQL
– user3590637
Nov 19 at 12:30






it was a quiz for a potential employer that was about JS but these 2 questions were tagged on at the end so i need abit of help understanding how to do them before i start to properly learn SQL
– user3590637
Nov 19 at 12:30














Hint for the first question: order by, hint for the second question join
– a_horse_with_no_name
Nov 19 at 12:32




Hint for the first question: order by, hint for the second question join
– a_horse_with_no_name
Nov 19 at 12:32












thanks for the hints, im assuming ORDER BY NAME DESC; would work from what i can see
– user3590637
Nov 19 at 12:35






thanks for the hints, im assuming ORDER BY NAME DESC; would work from what i can see
– user3590637
Nov 19 at 12:35






2




2




Why not simply create the tables and insert some data. Then it's easy to verify your queries.
– jarlh
Nov 19 at 12:51




Why not simply create the tables and insert some data. Then it's easy to verify your queries.
– jarlh
Nov 19 at 12:51

















active

oldest

votes






















active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes

-

Popular posts from this blog

404 Error Contact Form 7 ajax form submitting

Image
0 The contact form does not work, and affects loading after one try. The chrome console shows the error message: POST http://example.com/wp-json/contact-form-7/v1/contact-forms/50/feedback 404 (Not Found) send @ jquery.js?ver=1.12.4:4 ajax @ jquery.js?ver=1.12.4:4 wpcf7.submit @ scripts.js?ver=5.0.3:346 (anonymous) @ scripts.js?ver=5.0.3:53 dispatch @ jquery.js?ver=1.12.4:3 r.handle @ jquery.js?ver=1.12.4:3 How to solve this issue? thanks in advance javascript wordpress contact-form-7 share | improve this question edited Jul 17 '18 at 5:39 Kiran Shahi 4,745 3 16 43 ...
Read more

How to know if a Active Directory user can login interactively

Image
1 I would like to know if and how is it possible to know if a AD user can login interactively (on a server) in a domain. I need to know if I can find it out using a LDAP search. Thanks. windows active-directory login user-permissions user-profile share | improve this question edited 1 hour ago yagmoth555 ♦ 11.6k 3 17 42 asked 1 hour ago Luigi Luigi 6 1 New contributor ...
Read more

Refactoring coordinates for Minecraft Pi buildings written in Python

Image
0 $begingroup$ I'm fairly new to coding and I wrote this script in Python for a house with a roof in Minecraft Pi. I've found different ways to write the coordinates to make the code base shorter, but I'm wondering if it is possible for me to refactor it any further so I don't have to list each coordinate line by line. import mcpi.minecraft as minecraft import mcpi.block as block mc = minecraft.Minecraft.create() p = mc.player.getTilePos() mc.setBlocks(p.x+1, p.y, p.z+1, #Main structure starting coordinates (DO NOT ALTER) p.x+19, p.y+4, p.z+6, #Structure size/coordinates (Alters cube size) block.STONE_BRICK) mc.setBlocks(p.x+2, p.y+1, p.z+2, #Hollowing out main structure interior p.x+18, p.y+3, p.z+5, block.AIR) mc.setBlocks(p.x, p.y...
Read more