Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
BseConocimientoQuerys
query:- read(A), read(B), read(C), q1(B,A), q2(A,B,C). q1(X,Y):- write('select '), write(X), write(', count()/(select count() from '), write(Y), write(') as probabilidad from '), write(Y), write(' where '), write(X), write(' in(select distinct '), write(X), write(' from '), write(Y), write(') group by '), write(X), write(';\n'). q2(X, Y, Z):- write('select '), write(Y), write(', '), write(Z), write(', count()/(select count() from '), write(X), write(') as Probabilidad from '), write(X), write(' where '), write(Y), write(' in(select distinct '), write(Y), write(' from '), write(X), write(') and '), write(Z), write(' in(select distinct '), write(Z), write(' from '), write(X), write(') group by '), write(Y), write(', '), write(Y), write(' order by '), write(Y), write(', '), write(Z), write(';\n'). :- query.
run
|
edit
|
history
|
help
0
Query-Guerrero Hernandez Angel
Gerry3
Tarea 27/08/2021
1 clase1
Clase 4, con function
Clase 19/5-1
Atributos Infinitos
Tarea de else, Angel Guerrero
RuizRodriguezEdwinAndres-P2
Tarea - Ejercicio IF-ELSE - Guzmán Martínez Ricardo Alejandro