Posts by viviane araujo • 25 points

• -1

  votes

  1

  answer

  29

  views

  Q: Why is my function turning some strings into separate characters when sending them to the CSV file?

  I created the function below to save the information of a Json to a CSV. But it saves what is being displayed in the OUTPUT. I need the information to stand next to each other and the words not to…

  python csv

  asked 4 years, 2 months ago viviane araujo 25

• -4

  votes

  2

  answers

  69

  views

  Q: How do I extract the number of orders with 5 different items? I have this query but it is coming out a different result than expected

  SELECT DISTINCT(pedidos.id_pedidos),produtos.nome_produto FROM pedidos INNER JOIN itens_dopedido ON itens_dopedido.id_pedido=pedidos.id_pedidos INNER JOIN produtos ON…

  mysql sql database

  asked 4 years, 5 months ago viviane araujo 25

• -3

  votes

  2

  answers

  193

  views

  Q: I was given this exercise: "ALL CUSTOMERS WHO BOUGHT MORE THAN R$ 200,00 LAST MONTH"

  SELECT clientes.nome,clientes.sexo, SUM(pedidos.valor_pedidos) AS total_gasto,clientes.cidade FROM clientes INNER JOIN pedidos ON clientes.id_clientes = pedidos.id_clientes WHERE sexo LIKE 'F%' AND…

  php mysql sql

  asked 4 years, 5 months ago viviane araujo 25