Sfrgttk

Are small insurances worth it

Is there any relevance to Thor getting his hair cut other than comedic value?

Wrap all numerics in JSON with quotes

How to kill a localhost:8080

Difference between 'stomach' and 'uterus'

Borrowing Characters

Is there a math equivalent to the conditional ternary operator?

Does an unattuned Frost Brand weapon still glow in freezing temperatures?

Achieving MPPT of a solar panel with LM2596

Book about a time-travel war fought by computers

What is better: yes / no radio, or simple checkbox?

How do you say "powers of ten"?

Is the withholding of funding notice allowed?

VAT refund for a conference ticket in Sweden

Skis versus snow shoes - when to choose which for travelling the backcountry?

How do ISS astronauts "get their stripes"?

Can I become debt free or should I file for bankruptcy? How do I manage my debt and finances?

A bug in Excel? Conditional formatting for marking duplicates also highlights unique value

What type of postprocessing gives the effect of people standing out

Do higher etale homotopy groups of spectrum of a field always vanish?

In iTunes 12 on macOS, how can I reset the skip count of a song?

If nine coins are tossed, what is the probability that the number of heads is even?

How to mitigate "bandwagon attacking" from players?

How to lift/raise/repair a segment of concrete slab?

Return value from SELECT query filtered with

0

Quick question here. I have a DB with a few tables, not much, but they are linked with reference keys. Here is my problem:

• Return the sigil of the courses not yet taught by teacher whose name is 'Velvet' , 'Moise'

I can easily write the request, but I can't seem to find the right logic behind it.

Here is what I tried :

SELECT g.sigil

FROM   GroupCourse g JOIN Professor p

       ON g.profCode = p.profCode

WHERE  p.name != 'Velvet' AND p.name != 'Moise'

It works like it should, but if I have other teachers teaching the course too, let's say TRX1277, it will only remove the one that Velvet and Moise taught. Not all of them. I want to show only those who haven't been taught by those 2.

I know I'm missing a small thing, but I can't find it :(

oracle sqlplus

share

asked 1 min ago

Guillaume LévesqueGuillaume Lévesque

1

New contributor

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

add a comment | 

0

Quick question here. I have a DB with a few tables, not much, but they are linked with reference keys. Here is my problem:

• Return the sigil of the courses not yet taught by teacher whose name is 'Velvet' , 'Moise'

I can easily write the request, but I can't seem to find the right logic behind it.

Here is what I tried :

SELECT g.sigil

FROM   GroupCourse g JOIN Professor p

       ON g.profCode = p.profCode

WHERE  p.name != 'Velvet' AND p.name != 'Moise'

It works like it should, but if I have other teachers teaching the course too, let's say TRX1277, it will only remove the one that Velvet and Moise taught. Not all of them. I want to show only those who haven't been taught by those 2.

I know I'm missing a small thing, but I can't find it :(

oracle sqlplus

share

asked 1 min ago

Guillaume LévesqueGuillaume Lévesque

1

New contributor

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

add a comment | 

Quick question here. I have a DB with a few tables, not much, but they are linked with reference keys. Here is my problem:

• Return the sigil of the courses not yet taught by teacher whose name is 'Velvet' , 'Moise'

I can easily write the request, but I can't seem to find the right logic behind it.

Here is what I tried :

SELECT g.sigil

FROM   GroupCourse g JOIN Professor p

       ON g.profCode = p.profCode

WHERE  p.name != 'Velvet' AND p.name != 'Moise'

It works like it should, but if I have other teachers teaching the course too, let's say TRX1277, it will only remove the one that Velvet and Moise taught. Not all of them. I want to show only those who haven't been taught by those 2.

I know I'm missing a small thing, but I can't find it :(

oracle sqlplus

share

asked 1 min ago

Guillaume LévesqueGuillaume Lévesque

1

New contributor

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

SELECT g.sigil

FROM   GroupCourse g JOIN Professor p

       ON g.profCode = p.profCode

WHERE  p.name != 'Velvet' AND p.name != 'Moise'

share

asked 1 min ago

Guillaume LévesqueGuillaume Lévesque

1

New contributor

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

share

asked 1 min ago

Guillaume LévesqueGuillaume Lévesque

1

New contributor

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

asked 1 min ago

Guillaume LévesqueGuillaume Lévesque

1

New contributor

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

asked 1 min ago

Guillaume LévesqueGuillaume Lévesque

1