Sesiones de PyR

Write a query to output the apartments whose prices are greater than the average and are also not rented, sorted by the 'Price'.

27th Dec 2017, 3:23 AM

Sohana Saheen

0 Votos

Query the list of CITY names starting with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.

20th Jul 2021, 6:43 AM

Abhijeet Mandal

0 Votos

What will be the result of the query below? Explain your answer and provide a version that behaves correctly.

19th Dec 2016, 9:54 AM

Akwin Lopez

challenge

-1 Voto

Write query to find total salary to be paid in 5 years after annual increment of 5% on last year salary of every employees..

21st Dec 2016, 5:21 AM

Akwin Lopez

database datatype dbms mysql rdbms server sql

0 Votos

Group by Time as varchar every 30 min

27th Jul 2022, 4:55 AM

Dumb Coder 🤡

db oracel query

0 Votos

23rd Mar 2020, 12:17 PM

Ghaida

What is the use of SQL ?

data language query

-3 Votos

select round( sysdate, month) from dual; in this query if we use number instead of sysdate.. it shows error.. why?

29th Apr 2020, 10:47 AM

narayanapuram harikrishna

0 Votos

I have made a table employee where are 2 employee having same designation what command or query i should use to show name & id

4th Oct 2016, 7:08 PM

S.Akbar Sheriff

0 Votos

I need help from a very experimented programer. I need a form that lets to the web visitor make all query he wants on my db

21st Oct 2019, 8:01 PM

Disha Dey

database mysqli php

2 Votos

Sometimes sql query depends upon database used...for example oracle does not support LIMIT clause whereas mySQL does.Is it true??correct me if i am wrong.

3rd Apr 2017, 4:00 PM

Fausto Gutman

0 Votos

Write a query to output the apartments whose prices are greater than the average and are also not rented, sorted by the 'Price'.

9th Sep 2016, 8:01 AM

Vipul Newaskar

-6 Votos

Share the languages you all know so that everybody can interact better and can feel proud of you.

14th Sep 2022, 4:05 AM

Mohit Namdev

coding colleagues friend programming query sololearn

7 Votos

10 Respuestas

7th May 2017, 8:47 AM

Vishnu ks

Why am I unable to unlock new lessons?

beginner doubt learner practice query

2 Votos

Do we can use superscript and subscript in oracle and sql? If yes then what is the query for it.

23rd Apr 2022, 11:09 AM

Vaibhavi

oracle sql

1 Voto

18th Jan 2017, 7:28 AM

Deepika Behera

Projects? Meaning?

projects python query

0 Votos

Hi! Can you suggest me a way to learn about Databases and SQL Language? At school I study this , but I have more difficult...

17th Dec 2016, 12:35 PM

Ateeb Ahmed

beginners database query sql

0 Votos

Query the list of CITY names have vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.

5th Dec 2019, 9:07 PM

Niko

0 Votos

How to create/write a SQL query to find the salesperson and customer who belongs to same city. Return salesman, cust_name&city

19th Dec 2016, 9:57 AM

Akwin Lopez

lauren

-1 Voto

If I was given 6enteries to a row and and if I need to add in middle of the table what query I must use?

4th Mar 2022, 1:55 AM

Lauren Terez

insert sql

0 Votos

Тoday a customer want a cake set that has minimal calories. Write a query to sort the cakes by calorie count and select the fir

5th Aug 2016, 4:47 PM

sriram muralidharan

-1 Voto

What is the problem in the below code? Why don't I get the output? Also tell why when I view this in browser I see blank Webpage

20th Apr 2022, 1:19 PM

Drex 1

php programming query sololearn

2 Votos

To find the names of the customers between 30 to 40 years of age, set up the query as seen here:

13th May 2017, 1:33 PM

Vishnu ks

recode

0 Votos

Which should be preferable considering query cost ? joins should be used in sql queries OR Inner query(sub queries) is best.

3rd Apr 2018, 5:27 AM

Yiwen Zhao

php sql subqueries

1 Voto

How do i connect to a database, all my php codes are ready but i thing i have little problem with the query

20th Oct 2017, 7:04 PM

Shaikh Mehboob Siraj

localhost.mysql,phpmyadmin,

0 Votos

Need to write a query that returns the total profit made from 1Q of 2011- 4Q of 2016 in PgAdmin(sql). How do i go about this?

18th Jun 2017, 8:59 PM

SkyeTech

coding postgres query sql

0 Votos

Hi I want to use media query in css in div element to resize it's height according to device. Can anyone send me whole process?

23rd Aug 2020, 3:35 PM

Chudyn

css

0 Votos

friends, my head is loaded..can u plz remind me where i can find @media query lessons, is it in html5 or css?...i just can't get

6th Oct 2020, 5:18 PM

Ajay Rai

0 Votos

Can sme1 give me the command to this query Get the first name, city, country, and invoiced amount of customers living either in Brazil or in Paris and with a total invoice greater than $38.

3rd May 2017, 3:55 PM

Kelvine De Danielo

sql where

1 Voto

12 Respuestas

13th Sep 2016, 6:20 PM

Freeman Phiri

When we perform Arithmetic Operation in SELECT query It also reflect to our original DATABASE or it only Display the result (i.e

database query sql

0 Votos

write sql query if you are given a schema of two table named Customers and Orders, you should select the Name of all customers w

8th Oct 2016, 6:08 AM

Pranay Neema

customer jquery orders sql

0 Votos

Write a query to output all teams which conceded the least number of goals in the league ordered by scored goals in descending??

25th Aug 2022, 12:29 PM

Navnath Bulkunde

-4 Votos

Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.

26th May 2021, 1:31 PM

saffadya devan

0 Votos

Can we overload Main method in Java? And what if if did overload it i.e. from which method the main thread will start from?

11th Nov 2022, 5:27 PM

Muruga Perumal

java main methods query

1 Voto

php variable into mysql database

21st Nov 2017, 6:34 PM

Riyashi Chandak

button database favorites html php query

0 Votos

9 Respuestas

2nd Jul 2020, 8:57 PM

newbiecoder

Date before 1980 (SQL)

date mysql programming query sql tables

0 Votos

6 Respuestas

16th Nov 2020, 11:28 PM

Kevin

I can see a several languages over here.How Are They Different from each other? Like some are programming languages, query lang.

c++java language query scripting

1 Voto

11th Sep 2017, 2:58 AM

Ishu Maurya

Software for SQL

dbms query software sql

1 Voto

How to fetch data selecting radio button in php??

1st Jul 2020, 6:23 AM

Isha Shekh

html php query sql

1 Voto

Sum value from every 4 months

7th Jun 2017, 4:11 PM

Sultan Belai

functions query sql sum

0 Votos

Please am urgently in need of an ExpressJS developer for a clarification on how to create an endpoint that accepts query string

9th Nov 2017, 4:38 AM

Himas Adin Nugroho

expressjs

0 Votos

What is the best way to import a sql file into a js file by node and how to use sql file query in the js file

10th Jan 2021, 5:38 PM

kemzy

node.js sql

1 Voto

I am about to complete introduction to HTML ,I am from non IT background ,what should i do next

10th Jun 2020, 9:17 PM

Arsham Aazami

confused doubt it non query

0 Votos

Is it worth getting the Pro version?

27th Dec 2022, 11:07 AM

Kamil Dhanani

beginner help query support

0 Votos

26th Apr 2020, 12:56 AM

Md. Niamul Ahad Chowdhury

Where am I going wrong??

join mysql query sql

0 Votos

write SQL query for following To list all the columns of the table 'employee' in ascending order of department number and descending order of salary.

4th Aug 2022, 9:59 PM

Shiva Shankari Rajaram

1 Voto

15th Dec 2016, 4:18 PM

DHEERAJ

[SOLVED] Sololearn Pro

currency nok pro query sololearn solved

1 Voto

Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each

13th Jul 2020, 3:19 PM

Emanuel Maliaño

0 Votos

How this code executes : 4 ?

19th Dec 2016, 9:34 AM

Akwin Lopez

code if java loop query while

2 Votos